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)
)
AlienSx's avatar
AlienSx
Super User
2 years ago

Hello, Anonymous 

Table.AddColumn(
  #"Renamed Columns",
  "TF",
  (x) => List.MatchesAll(Record.FieldValues(x), (y) => y = null)
)