Forum Discussion

Frequent Visitor

4 years ago

Solved

Visuals Not Showing Latest Data For Current Year

Hello, I'm stuck with yet another problem. I have inventory data that goes from 2019 - June 2022. The way the inventory table is formatted is that each particular item has an inventory value. I n...

Tutorial Requests

amitchandak
4 years ago
comacabana , Try

Inventory EOM =
CALCULATE(lastnonblankvalue('Date'[Date], '_Measures Inventory'[Total Inv]))

or

Inventory EOM =
CALCULATE(CLOSINGBALANCEMONTH('_Measures Inventory'[Total Inv], LASTDATE('Date'[Date])))

Frequent Visitor

4 years ago

Perfect! Thank you so much amitchandak you're a life saver