Forum Discussion
ovetteabejuela
Impactful Individual
Impactful IndividualPower 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...
parry2k
Super User
Super Userovetteabejuela not sure why this will not work,
if [column1] = null and [column2] = null and [column3] = null and [column4] = null then "Yes" else "No"
in query editor it loads first 999 rows and when you refresh, it goes thru whole data set and I guess there is some issue when whole dataset get loaded.
Quick question, if you don't add this custom column, do you still get error? May be it is not this column but other error.
ovetteabejuelaImpactful Individual
Impactful Individual"in query editor it loads first 999 rows and when you refresh, it goes thru whole data set and I guess there is some issue when whole dataset get loaded."
Yeah, i think this might be it, I will need to investigate further.