Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have created a measure to display cumulative total using the guidelines on daxpatterns.com.
Measure:
Sales Acc = CALCULATE(Sales[SalesAmount];FILTER(ALL(Dates);Dates[Date]<=MAX(Dates[Date])))
My date table goes beyond the last sales date leaving me with a simple line chart, that visually doesn't work.
The question is:
How do I change the measure so I can get picture A instead of picture B? I would prefer not to set the filter manually on the visual, but let it be dynamic.
Solved! Go to Solution.
In your scenario, since your date table goes beyond the last sales date, so some date have no sales. So your get Picture B. If you want the expected reults, you need to filter out the dates which have no sales.
You need to create a column in your date table to check if the current date is before than the max date in your sales date.
Column = IF('Date'[DateKey]<MAX(Sales[DateID]),1,0)
Then add this column to your visual filter.
Regards,
Charlie Liao
Hi,
I think that instead of this
Sales Acc = CALCULATE(Sales[SalesAmount];FILTER(ALL(Dates);Dates[Date]<=MAX(Dates[Date])))
it should be
Sales Acc = CALCULATE(Sales[SalesAmount];FILTER(ALL(Dates);Dates[Date]<=MAX(Sales[SalesDate])))
you want the MAX of the SalesDate from the Sales Table.
In your scenario, since your date table goes beyond the last sales date, so some date have no sales. So your get Picture B. If you want the expected reults, you need to filter out the dates which have no sales.
You need to create a column in your date table to check if the current date is before than the max date in your sales date.
Column = IF('Date'[DateKey]<MAX(Sales[DateID]),1,0)
Then add this column to your visual filter.
Regards,
Charlie Liao
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
88 | |
82 | |
65 | |
64 | |
58 |
User | Count |
---|---|
171 | |
112 | |
110 | |
72 | |
72 |