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.
Looking to Calculate the Consecutive Weeks (Rows) at 'Combined Color' filtered by 'Project ID'
Ideally, it would be a Column that would count how many weeks (Rows) it was at the same 'Combined Color'
Expected Result Project ID 344 , Index 4, Combined Color Orange, Count 2
PBi File for Troubleshooting issues online.pbix
I have figured out a way to calculate consecutive rows, unfortunately, that is as far as I have got thus far.
Solved! Go to Solution.
Solved by this Calculated Column:
Solved by this Calculated Column:
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 |
---|---|
107 | |
98 | |
78 | |
65 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |