Cumulative graph value on specific date

[Anonymous]

Hi guys. Is it possible to get a value for a specific date from a cumulative graph and put that in a card or taco visual for example?

I cannot currently do it as the measure for the cumulative graph is dependent on a rolling date axis.

[Andre_Jaar · Accepted solution]

Sure...

Measure = 
  VAR DateYouWant = DATE(2020,5,1)  // Or...a MAX() of any table, you choose

RETURN
  CALCULATE( [measureyouwant] , FILTER( ALL( CalendarTable ) , CalendarTable[Date] <= DateYouWant) )

[amitchandak]

@Anonymous , Not very clear

try like

Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(date,date[date] <=maxx(date,date[date])))
Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(date,date[date] <=max(Sales[Sales Date])))

[Anonymous]

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490