Forum Discussion
ovetteabejuela
7 years agoImpactful Individual
Power Query | A little help on Comparing Nulls
So, I want to see if multiple columns are nulls and if they are filter them out. My first attempt was something like if [column1] = null and [column2] = null and [column3] = null and [column4...
v-danhe-msft
7 years agoMicrosoft Employee
Hi ovetteabejuela,
Could you have tried with the 'Add conditonal column' function in query editor?
Reference:https://excelkingdom.blogspot.com/2017/12/how-to-add-conditional-column-to-table.html
Regards,
Daniel He