Hi everyone!
Want to create a query step* where the first column of a table is removed (and then the rest of the columns get renamed) only if a specific value** inside that table is null. Otherwise, the table is passed to the next step as is.
------------------------------------------
This is how I tried implementing it, but please also feel free to propose a solution from scratch instead of correcting the mess I created; since I am pretty new to Power BI don't know how much sense my solution makes in the first place 😂
Draft Solution
= if ISBLANK(#"Navigation"{3}[Column1]) then
(Table.RemoveColumns(#"Navigation",{"Column1"}) and
Table.RenameColumns{{"Column2", "Column1"}, {"Column3", "Column2"}, {"Column4", "Column3"}, {"Column5", "Column4"}, {"Column6", "Column5"}, {"Column7", "Column8"}, {"Column8", "Column9"}})
else #"Navigation"
(Note that the table comes after a Navigation step so I reference it as #"Navigation" and the value** that gets checked is the third row of the first column.)
Thank you very much for your time!
Notes
* It could also be a function, if that's easier to implement.
** If that value is null, then the whole column is null; however, it's not that this cell has a special importance or anything -
might as well do a check at the column level. Just thought that checking only one value would improve performance.
