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

Hello AlienSx 
I entered in the formula exactly how you had it and also tried to add the first column of the range in for (y) and the last for the y but it is showing Falses even for rows that have data in every column unfortunately.