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.
Hey looking for a way to sum a column by limiting the sum (of Flags) to the current and previous 3 rows. These events have date time stamps, but the time delta between the transactions is not exact to do a rolling cumulative by a datesbetwen function. And specifically we only want the past 4 transactions to be counted.
DTS Value Flag RollingFlagCount
12:21 5.5 1 1
12:22 6.0 0 1
12:30 6.2 1 2
12:33 6.3 1 3
12:35 3 0 2
Solved! Go to Solution.
Hi @dacoil,
You can use below formula to get the grouping rolling count.
Sample measure:
RollingCount = COUNTX(FILTER(ALL(test),[DTS]<=MAX(test[DTS])&&[Flag]=MAX(test[Flag])),[Flag])
Regards,
Xiaoxin Sheng
Hi @dacoil,
You can use below formula to get the grouping rolling count.
Sample measure:
RollingCount = COUNTX(FILTER(ALL(test),[DTS]<=MAX(test[DTS])&&[Flag]=MAX(test[Flag])),[Flag])
Regards,
Xiaoxin Sheng
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 |
---|---|
110 | |
97 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |