Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Get inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.

Reply
umaluagr
New Member

Delete the rows if the value in one column is null

‎04-16-2024 04:18 AM

Hi community

 

I have a table with 20 columns. If the value in column 5 is null I want to delete this row automatically. The table is constantly filled and I want to avoid having those incorrect rows in there. So, IF column 5 IS null THEN delete row. I am sure there is an easy solution out there. I just don't get it.

Labels:
Message 1 of 4
387 Views
0
1 ACCEPTED SOLUTION
dufoq3
Super User
Super User

‎04-16-2024 04:23 AM

Hi @umaluagr,

yes, there is 🙂 Just filter out null value for [Column5]

dufoq3_0-1713266576146.png

 


Note: Check this link to learn how to use my query.
Check this link if you don't know how to provide sample data.

View solution in original post

Message 2 of 4
380 Views
3 REPLIES 3
dufoq3
Super User
Super User

‎04-16-2024 04:23 AM

Hi @umaluagr,

yes, there is 🙂 Just filter out null value for [Column5]

dufoq3_0-1713266576146.png

 


Note: Check this link to learn how to use my query.
Check this link if you don't know how to provide sample data.

Message 2 of 4
381 Views
umaluagr
New Member
In response to dufoq3

‎04-16-2024 04:25 AM

Thank you for the quick help. I was thinking far too difficult. 

Message 3 of 4
377 Views
0
dufoq3
Super User
Super User
In response to umaluagr

‎04-16-2024 04:36 AM

You're welcome.


Note: Check this link to learn how to use my query.
Check this link if you don't know how to provide sample data.

Message 4 of 4
369 Views
0

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

View All