Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
pedroccamaraDBI
Post Partisan
Post Partisan

Value from last day (calendar date)

Hello all

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

apagar10.JPG
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

1 ACCEPTED SOLUTION

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

 

 

View solution in original post

4 REPLIES 4
amitchandak
Super User
Super User

@pedroccamaraDBI ,Try measure liek

 

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

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).
Capture100.JPG

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

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

 

 

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

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.