You to Everyone 17:32 Opening Stock Level = CALCULATE(SUM(ProductInventory[UnitsBalance]),ProductInventory[Date] = MIN(ProductInventory[Date])) You to Everyone 17:41 Closing Stock Level = CALCULATE(SUM(ProductInventory[UnitsBalance]),ProductInventory[Date] = MAX(ProductInventory[Date])) You to Everyone 17:57 Current Assets = CALCULATE([Finance Amount],AccountHierarchy[L3]="Current Assets") Current Liabilities = CALCULATE([Finance Amount],AccountHierarchy[L4]="Current Liabilities") Working Capital = [Current Assets] - [Current Liabilities] Net Income = CALCULATE([Finance Amount], AccountHierarchy[L1] = "Net Income") Total Assets = CALCULATE([Finance Amount],AccountHierarchy[L2]="Total Assets") Return on Assets = DIVIDE([Net Income],[Total Assets],0) Cash = CALCULATE([Finance Amount],AccountHierarchy[L4]="Cash") You to Everyone 18:02 Cash Ratio = DIVIDE([Cash],[Current Liabilities],0) Current Ratio = DIVIDE([Current Assets],[Current Liabilities],0) You to Everyone 18:19 Headcount = CALCULATE([Finance Amount],AccountHierarchy[AccountDescription]="Headcount")