Search code examples
nullpowerbidata-cleaning

Remove null values from whole data in Power BI

I have 20+ tables and also there are a lot more columns so it's is not possible to filter out null values one by one for each column, Is there any alternative to remove null values from whole data in one go.

Solution

  • filter all null values for multiple columns at one time with the M Query below

    #"Filtered Rows" = Table.SelectRows(#"Changed Type", each List.Contains(Record.ToList(_),null)=false)

    This will help.