Skip to content

Create account

DEV Community

Nilotpal Choudhury

Posted on Nov 1, 2020

Answer: Remove null values from whole data in Power BI

#powerquery #null #filter

answer re: Remove null values from whole data in Power BI

Apr 26 '19

6

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.

Top comments (0)

Subscribe

The Next Generation Developer Platform

Coherence is the first Platform-as-a-Service you can control. Unlike "black-box" platforms that are opinionated about the infra you can deploy, Coherence is powered by CNC, the open-source IaC framework, which offers limitless customization.

Learn more

DEV Community

Answer: Remove null values from whole data in Power BI

answer re: Remove null values from whole data in Power BI

Top comments (0)

The Next Generation Developer Platform

Read next

Indie Hacking Success Stories with Open Source Licenses

The Unintended Consequences: How Trump Administration Policies Shaped Open Source Licensing

IBM's Pioneering in Digital Innovation: Open Source & Blockchain

How to Create a Custom Short URL for My Brand?

Okay