Forum Discussion
Pulling most recent value
Hi all, For some reason I am struggling to figure out how to pull the last value, the column is a calculated column (each row contains a 0 or 1 the field has been set to average). When I put the ...
The following worked for me
Measure =VAR Max_Date = MAX(Table[Date])VAR Latest_MS = CALCULATE([Measure2],Table[Date]=Max_Date)Return Latest_MSSource: Get Most recent/Max Date value in PowerBI using DAX | MiTutorials - YouTube
amitchandak
Super User
Super UserAnonymous , Try like
lastnonblankvalue(TABLE[Date],SUM(Table[Product Sales]))
amitchandak Thank you for your response.
Unfortunately it did not work, it ended up returning the latest date when I put the measure into a card.
The following worked for me
Measure =VAR Max_Date = MAX(Table[Date])VAR Latest_MS = CALCULATE([Measure2],Table[Date]=Max_Date)Return Latest_MSSource: Get Most recent/Max Date value in PowerBI using DAX | MiTutorials - YouTube