Forum Discussion

selpaqm's avatar
selpaqm
Icon for Helper V rankHelper V
6 years ago
Solved

removing rows with blank value on multiple columns

Hi,   ı have an huge table and I want to simplify it with removing blank rows. I have tried power query add custom column and conditional column methods and cannot succeed. source file is csv on s...
Need Help
  • Fowmy's avatar
    Fowmy
    6 years ago

    selpaqm 

    In Power Query, Select All three Columns (salesman,country ,customer). 
    On the Add Column Tab, Click Merge Column,
    In your new Column, Filter out blank,

    You get the desired results

     

     


    You can delete the merged column

    ________________________

    If my answer was helpful, please consider Accept it as the solution to help the other members find it

    Click on the Thumbs-Up icon if you like this reply 🙂

    YouTube  LinkedIn

Pragati11's avatar
Pragati11
Icon for Super User rankSuper User
6 years ago

HI selpaqm ,

 

I am assuming you have got blank values in all of the mentioned columns in source data and they have TEXT data-type.

 

Create a column as below using DAX expression:

IfBlankValue = IF ([Salesman] = BLANK() && [country] = BLANK() && [customer] = BLANK(), 0, 1)

 

Create a visual like the table you have shared in your screenshot. On this table visual, move IfBlankValue as a visual level filter and select value IfBlankValue = 1

 

Let me know if this approach works.

 

Thanks,

Pragati