Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello everyone,
I have an issue and i'm stuck.
I try to make a sum of PTS of the last fives dates. As you can see, it's rolling by the following dates.
For the rows 5,4,3,2,1 . I'm just making a cumulate until I have 5 rows of dates.
Thanks a lot for your help.
Regards
Kevin
Solved! Go to Solution.
OK, so I did this:
Index = COUNTROWS(FILTER('Table',[date] <= EARLIER([date])))
And then this:
Rolling 5 Last Days =
VAR __Count = COUNTROWS(FILTER('Table',[date] <= EARLIER([date])))
VAR __Min = [Index] - 5 + 1
RETURN
IF(
__Count >= 5,
SUMX(FILTER('Table',[Index] >= __Min && [Index] <= EARLIER([Index])),[PTS]),
SUMX(FILTER('Table',[date] <= EARLIER([date])),[PTS])
)
PBIX is attached.
OK, so I did this:
Index = COUNTROWS(FILTER('Table',[date] <= EARLIER([date])))
And then this:
Rolling 5 Last Days =
VAR __Count = COUNTROWS(FILTER('Table',[date] <= EARLIER([date])))
VAR __Min = [Index] - 5 + 1
RETURN
IF(
__Count >= 5,
SUMX(FILTER('Table',[Index] >= __Min && [Index] <= EARLIER([Index])),[PTS]),
SUMX(FILTER('Table',[date] <= EARLIER([date])),[PTS])
)
PBIX is attached.
Hi Greg,
You're my hero ! I was tearing my hair all this time.
Thank you very much
Kevin
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
26 | |
21 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |