Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
102 | |
92 | |
85 | |
78 | |
71 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |