Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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:
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
84 | |
66 | |
62 | |
59 |
User | Count |
---|---|
197 | |
116 | |
107 | |
77 | |
70 |