Forum Discussion
Cumulative graph value on specific date
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.
Sure...
Measure =
VAR DateYouWant = DATE(2020,5,1) // Or...a MAX() of any table, you chooseRETURN
CALCULATE( [measureyouwant] , FILTER( ALL( CalendarTable ) , CalendarTable[Date] <= DateYouWant) )
3 Replies
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])))Sure...
Measure =
VAR DateYouWant = DATE(2020,5,1) // Or...a MAX() of any table, you chooseRETURN
CALCULATE( [measureyouwant] , FILTER( ALL( CalendarTable ) , CalendarTable[Date] <= DateYouWant) )
