Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Help with Formula Regarding 7 Columns Null/True/False

Hello! I have been trying to write a code in Power Query that allows me to have a custom column that comes back with either true or false If all of the columns selected in a row are nulls. I know I ...
Need Help
  • AlienSx's avatar
    AlienSx
    2 years ago

    Anonymous do you really have nulls? I've dropped first 3 columns:

    Table.AddColumn(
  #"Renamed Columns", 
  "TF", 
  (x) => List.MatchesAll(List.Skip(Record.FieldValues(x), 3), (y) => y = null)
)
Anonymous's avatar
Anonymous
Not applicable
2 years ago

I do have nulls. Entered this in and it worked. 
Do you know if there is a way to hide this True/False column now that I can filter out the rows with all nulls?
AlienSx 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Nevermind. I just deleted the Column and it kept the formatting. 
Thanks for the help!