I am still very new to Power Pivot & DAX Measures, so a little help would be greatly appreciated here!
I have the below table:
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.
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.
Universe
value whenUniverse
is blank, ie. no implicit value. In the above example, forChannel A
I wantUniverse
to return most recent (ie. July value 898), and forChannel B
I wantUniverse
to return most recent (ie. July value 1383) – DeanUniverse
to retrun based on the first table in my post... – Dean