Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
I'm trying to create a running total that will start from 0, based on the filtered date.
For example, if the sales for the years were:
2018: £100
2019: £200
2020: £500
Currently if I set the slicer to 2019, the running total would be:
2019: £300
2020: £800
But I would want it to be:
2019: £200
2020: £700
Thanks in advance!
Solved! Go to Solution.
@bmay14 , Try like
Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected(date),date[date] <=max(date[Date])))
or
Cumm Sales =
var _min = minx(allselected('Date'), 'Date'[Date])
return
CALCULATE(SUM(Sales[Sales Amount]),filter(all(date),date[date] <=max(date[Date]) && date[date] >= _min))
@bmay14 , Try like
Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected(date),date[date] <=max(date[Date])))
or
Cumm Sales =
var _min = minx(allselected('Date'), 'Date'[Date])
return
CALCULATE(SUM(Sales[Sales Amount]),filter(all(date),date[date] <=max(date[Date]) && date[date] >= _min))
Thank you! The second one worked 🙂
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
90 | |
84 | |
70 | |
49 |
User | Count |
---|---|
143 | |
121 | |
112 | |
59 | |
58 |