Forum Discussion
Solved
Sort by Column sends error for rows with BLANK() values / Spaces
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". ...
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])