topic Re: Value from last day (calendar date) in DAX Commands and Tips

Value from last day (calendar date)

pedroccamaraDBI — Tue, 25 Jan 2022 15:39:06 GMT

Hello all

I have this table and a date filter from calendar table.

The date filter is from 5 oct till 11 oct . I want that my measure shows the unit stocks for that last day 11/10 which would be 106 for each SKU column.
Thank you all very much

Re: Value from last day (calendar date)

amitchandak — Tue, 25 Jan 2022 16:26:12 GMT

pedroccamaraDBI ,Try measure liek

calculate(lastnonblankvalue('Date'[Date], sum(Table[Unit stock]) )

Re: Value from last day (calendar date)

pedroccamaraDBI — Tue, 25 Jan 2022 17:22:27 GMT

Hello amitchandak
Many thanks for your answer.
Let me explain you what is my data:
For each day, i have the product code (SKU) the movement id (ID Mov) and the Qty mov, which is how many products were moved and the Qty day which is the balance. I need to know, according with date filter (from dates) the Qty Day of the MAX date on the filter. Which means in this case, it should be 106. Notice that if i may choose 2 or 3 product codes (SKU).

My measure should show 106 in this case because it's the value from the last date chosen.
I'm not sure and even don't know how to, where to do it, but i believe we should have some kind of this: ALL (Products) in that measure, right?
Thanks a lot for your help

Re: Value from last day (calendar date)

SteveHailey — Tue, 25 Jan 2022 19:04:54 GMT

Hey pedroccamaraDBI.

Give this a try:

Measure = VAR MaxDate = CALCULATE ( MAX ( 'Date'[Date] ), ALLSELECTED ( 'Date'[Date] ) ) VAR Result = CALCULATE ( MAX ( Sales[Qty Day] ), 'Date'[Date] = MaxDate ) RETURN Result

Re: Value from last day (calendar date)

pedroccamaraDBI — Tue, 25 Jan 2022 19:23:42 GMT

Hello SteveHailey
Thank you so much for your help. You're the 7th person that i asked for help.
Best regards