Forum Discussion
Two Basic (I hope) Queries
To all
Please see attached basic Grid complete with basic data set.
Is it possible to:-
1. Customise the row order?
2. Replace the blanks with zeros (as you would in a Pivot in Excel)?
Thank you for you help
Mark Taylor
1 Reply
For the 2nd question, in Power Query Editor, right-click the column, Replace values, null, 0.
For the 1st question, that would depend on how you want to sort. But, be careful that you may need to use Table.Buffer for the sorting to "stick".
