Return Latest Value in Column Based on Date
10:14 10 Sep 2019

I am still very new to Power Pivot & DAX Measures, so a little help would be greatly appreciated here!

I have the below table:

enter image description here

I am trying to build a DAX measure that will return the latest [Universe] value. I have tried a combination of CALCULATE, MAX, FILTER, EARLIER, but am struggling to get the desired output, as seen below.

enter image description here

I don't necessarily want the outputs in a table, but rather in a measure because I want to use it in a calculation.

Note, this is my current attempt:

Total Universe:=SUM([Universe])

Last Universe Date:=CALCULATE(MAX([Date]),FILTER(tbData,LASTNONBLANK(tbData[Universe],1)))

Last Universe Value:=CALCULATE([Total Universe],FILTER(tbData,tbData[Date]=[Last Universe Date]))

Last Universe Date returns the correct date, but Last Universe Value returns the Grand Total value.

Any help/ guidance is appreciated.

dax powerpivot