topic Cumulative graph value on specific date in DAX Commands and Tips

Cumulative graph value on specific date

Anonymous — Fri, 17 Jul 2020 09:52:58 GMT

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.

Re: Cumulative graph value on specific date

Anonymous — Fri, 17 Jul 2020 11:11:23 GMT

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

Re: Cumulative graph value on specific date

amitchandak — Fri, 17 Jul 2020 12:27:27 GMT

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])))

Re: Cumulative graph value on specific date

Andre_Jaar — Fri, 17 Jul 2020 13:25:51 GMT

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) )