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.
I need to add a Row Number (1,2,3,4...) to a table that resets to (1,2,3,4...) when a filter is applied.
This is what I entered: *note: "ROW_NUM" is selected via SQL.
Solved! Go to Solution.
Decided to take the easy path and used a paginated report and added a column with =RowNumber("Contracts")
Could you elaborate on your ask? What do you mean by reset? Are you saying the row number should be per group? Also if you could share a sample data, that would be immensely helpful for us to troubleshoot.
By Reset I mean the row numbering should reset to 1,2,3,4... if a filter is applied like Cost Center "2252". The resulting rows would then show 1,2,3,4.... There are numerous filters that could be applied. The row sequence is based on Contract IDV which is unique for each row.
DCOO Cabinet Name Dept. Name Dept. Number COST_CENTER_NAME COST_CENTER CONTRACT IDV
"STANLEY, EDNA R" TRANSIT SERVICE DELIVERY BUS TRANSIT OPERATIONS 3233 OPERATIONS CENTRAL INSTRUCTION 3201 PS91211000
"STANLEY, EDNA R" TRANSIT SERVICE DELIVERY BUS TRANSIT OPERATIONS 3233 OPERATIONS CENTRAL INSTRUCTION 3209 PS134942000
"STANLEY, EDNA R" TRANSIT SERVICE DELIVERY BUS TRANSIT OPERATIONS 3233 OPERATIONS CENTRAL INSTRUCTION 3209 PS4071300
"STANLEY, EDNA R" TRANSIT SERVICE DELIVERY BUS TRANSIT OPERATIONS 3233 OPERATIONS CENTRAL INSTRUCTION 3209 PS79597000
"STANLEY, EDNA R" TRANSIT SERVICE DELIVERY BUS TRANSIT OPERATIONS 3233 OPERATIONS CENTRAL INSTRUCTION 3209 PS81176000
"AMIRI, SHAHRZAD" SHARED MOBILITY CONGESTION REDUCTION 2003 EXPRESSLANES 2220 PS48720000
"AMIRI, SHAHRZAD" SHARED MOBILITY CONGESTION REDUCTION 2003 EXPRESSLANES 2220 PS94845000
"AMIRI, SHAHRZAD" SHARED MOBILITY CONGESTION REDUCTION 2003 EXPRESSLANES 2220 PS401642000
"AMIRI, SHAHRZAD" SHARED MOBILITY CONGESTION REDUCTION 2003 EXPRESSLANES 2220 PS51236002
Decided to take the easy path and used a paginated report and added a column with =RowNumber("Contracts")
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
93 | |
87 | |
80 | |
69 | |
68 |
User | Count |
---|---|
226 | |
129 | |
119 | |
83 | |
77 |