Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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) )
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) )
@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])))