Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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])))
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
22 | |
7 | |
6 | |
6 | |
6 |
User | Count |
---|---|
27 | |
12 | |
10 | |
9 | |
6 |