Forum Discussion
Extract rate by latest date using DAX
I have a simple table with three columns of value:
Investment Product, Value Date, Unit Value
I want to use the Unit Value in a measure calculation, but it must give me the unit rate with the latest date.
How do I do that?
SOLVED: I found Lookup.... and LastDate....
1 Reply
hildasteyn I hope this help you
rate by latest date =CALCULATE(FIRSTNONBLANK ( [Sales Amount],'Table'[Date])
