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
Hello,
i have the following problem.
I want to have to SUM of the last 5 days from "Num1". Including the current day
"SUM1 LAST 5" ist the result, which i calculated in excel...but i need this one in power bi...
I used the following code for "SUM1 false", but it only sums up everything:
Solved! Go to Solution.
I've tried it and i'm getting the following error:
"A ring dependency was detected: Table1[Previous5DaySum], Table1[Sum Running Total], Table1[Previous5DaySum]."
This is the code:
Pardon Sir - i've added you the table. Is this ok?
Tag | Menge | Circulation | Circulation false | N Days |
02.01.2023 | 165 | 165 | 165 | 5 |
03.01.2023 | 520 | 685 | 685 | 5 |
04.01.2023 | 515 | 1200 | 1200 | 5 |
05.01.2023 | 510 | 1710 | 1710 | 5 |
06.01.2023 | 480 | 2190 | 2190 | 5 |
07.01.2023 | 1345 | 3370 | 3535 | 5 |
08.01.2023 | 1315 | 4165 | 4850 | 5 |
09.01.2023 | 1275 | 4925 | 6125 | 5 |
10.01.2023 | 1235 | 5650 | 7360 | 5 |
11.01.2023 | 1300 | 6470 | 8660 | 5 |
12.01.2023 | 1315 | 6440 | 9975 | 5 |
13.01.2023 | 1290 | 6415 | 11265 | 5 |
14.01.2023 | 750 | 5890 | 12015 | 5 |
15.01.2023 | 1305 | 5960 | 13320 | 5 |
16.01.2023 | 1310 | 5970 | 14630 | 5 |
17.01.2023 | 1350 | 6005 | 15980 | 5 |
18.01.2023 | 1330 | 6045 | 17310 | 5 |
19.01.2023 | 1005 | 6300 | 18315 | 5 |
20.01.2023 | 1205 | 6200 | 19520 | 5 |
21.01.2023 | 1300 | 6190 | 20820 | 5 |
22.01.2023 | 1010 | 5850 | 21830 | 5 |
23.01.2023 | 1230 | 5750 | 23060 | 5 |
24.01.2023 | 1405 | 6150 | 24465 | 5 |
25.01.2023 | 1400 | 6345 | 25865 | 5 |
26.01.2023 | 1340 | 6385 | 27205 | 5 |
27.01.2023 | 1010 | 6385 | 28215 | 5 |
28.01.2023 | 1230 | 6385 | 29445 | 5 |
29.01.2023 | 1405 | 6385 | 30850 | 5 |
30.01.2023 | 1400 | 6385 | 32250 | 5 |
31.01.2023 | 1340 | 6385 | 33590 | 5 |
01.02.2023 | 1405 | 6780 | 34995 | 5 |
02.02.2023 | 1400 | 6950 | 36395 | 5 |
03.02.2023 | 1340 | 6885 | 37735 | 5 |
@SHenryy
You can create What-If parameters for the dynamic value of Days (i.e. X).
Please see this link.
Then you can create the following DAX measure:
Previous5DaySum =
VAR CurrentDate = LASTDATE(table[DATE])
RETURN
CALCULATE(
SUM(table[NUM1]),
DATESBETWEEN(table[date], CurrentDate - [Parameter that you created], CurrentDate - 1)
)
Please let me know if this didn't work.
I've tried it and i'm getting the following error:
"A ring dependency was detected: Table1[Previous5DaySum], Table1[Sum Running Total], Table1[Previous5DaySum]."
This is the code:
This is an old collumn...which i dont use anymore? should i delete it?
i deleted all unnessary collumns.
But as a result my "Previous5DaySum" is now empty
True - but which kind of code did you use?
Yes, but it should already start in 2.Jan
@SHenryy , but it doesn't have any data before that, so how would it give any value?
@SHenryy
I created the following DAX measure:
Previous5DaySum =
VAR CurrentDate = LASTDATE('Tabelle1'[Tag])
RETURN
CALCULATE(
SUM('Tabelle1'[Menge]),
DATESBETWEEN('Tabelle1'[Tag], CurrentDate - 5, CurrentDate - 1)
)
pardon sir, how did you created this table?
Hi @SHenryy ,
Please post a sample data that one can easily copy-paste (not an image) and your expected result. Also I don't see Menge and Tag columns in your screenshot.
Proud to be a Super User!
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 |
---|---|
92 | |
86 | |
85 | |
66 | |
49 |
User | Count |
---|---|
140 | |
113 | |
106 | |
64 | |
60 |