Forum Discussion
hildasteyn
3 years agoHelper I
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 la...
Mahesh0016
3 years agoSuper User
hildasteyn I hope this help you
rate by latest date =
CALCULATE(
FIRSTNONBLANK ( [Sales Amount],'Table'[Date])