Forum Discussion
check if columns are blank/null
I need to find records where a group of columns all contain "null" values. If the specified columns only contain null values, then evaluate as false. If columns contain any value (ie <> blank), evalu...
Use below in your custom column where Query1 holds the list of columns
List.RemoveNulls(Record.ToList(Record.SelectFields(_, Query1))) <> {}
Not sure I understand your goal. You have a Reference list of data, say it contains rows with values "A" and "B" (rows not columns) Is that right?
And you want to manipulate the rows in this table, say, remove "A" and add "C", and have the results of the main query change to only look at columns B and C in the Power Query?
I have a list of 25 column names.
I have a dataset that has 100 columns. I want to check, for every row, whether there is data in any of those 25 columns. If there is a value in one of those 25 columns, return TRUE in new column. If that record only contains null values in those 25 columns, return FALSE.