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 want my P&L Report to contain blank rows.
When I inport this table to the model and try to sort the "PL Title" column by the "Order" column, it shows error for duplicate values in the "PL Title". I understand, they are blank rows with different order. I tried to enter different spaces, also I tried to use
non-printable spaces
Text.Repeat(Character.FromNumber(0032),[Index])
Still no luck.
Please help
Solved! Go to Solution.
Ok, I've found a solution.
I've repeated non-breaking spaces different times for different rows and it works.
Text.Repeat("#(00A0)",[Index])
Ok, I've found a solution.
I've repeated non-breaking spaces different times for different rows and it works.
Text.Repeat("#(00A0)",[Index])
User | Count |
---|---|
95 | |
89 | |
70 | |
63 | |
58 |
User | Count |
---|---|
149 | |
113 | |
95 | |
80 | |
72 |