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.
Hi everyone,
I have a table with data from 2016 to present, and I have a chart with the running total of the values.
This is the formula I've been using to calculate the running total:
SoftRunningTotal = CALCULATE(SUM(Data[SOFT_CAD]), FILTER(ALL(Data), Data[DATEVAL] <= MAX(Data[DATEVAL])))
My goal here is to start the calculation from the first date VISIBLE on the chart and not the first first. The way it is now, it's been calculating the sum since 2016 but showing only 2022
Some sample data:
Date | Value | Type |
2022-01-31 | 10 | Soft |
2021-12-31 | 15 | Soft |
2021-11-30 | 4 | Soft |
2021-10-31 | 12 | Soft |
2021-09-30 | 11 | Soft |
Use case:
Filter only 21-11-30, 21-12-31 and 22-01-31
Expected result: 4(Nov), 19(Nov+Dec), 29(Nov+Dec+Jan)
Current result: 27(Sep+Oct+Nov), 42(Sep+Oct+Nov+Dec), 52(Sep+Oct+Nov+Dec+Jan)
Long story short, I just want to start the calculation from the start date I set on the filter, and not the first at all.
Thanks a lot,
Leo
Solved! Go to Solution.
Hi,
Download my PBI file from here.
Hope this helps.
Hi,
Download my PBI file from here.
Hope this helps.
Yes! That's it. Thank you so much.
I did some modifications to use the page filter instead of the slicer and it's exactly how I want it.
Thanks @Ashish_Mathur
You are welcome.
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
84 | |
66 |