Forum Discussion

deb_power123's avatar
deb_power123
Icon for Helper V rankHelper V
5 years ago
Solved

Delete some rows completely with dependent columns in trasformation in PowerBI

Hi All,   I have a table Students with two columns in my input source data as shown  below :- Here Building and Floor are dependent columns for eg : Building A has 4 floors Floor1 through Floor4 a...
Need Help
  • v-robertq-msft's avatar
    v-robertq-msft
    5 years ago

    Hi, deb_power123 

    According to your description and sample data, I think that you can just simply use the “Filter data” function in the Power Query to prevent the rows with blank value in the [Floor] column to be imported into the Power BI, like this:

     

    And you can get what you want, like this:

     

    Thank you very much!

     

    Best Regards,

    Community Support Team _Robert Qin

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-robertq-msft's avatar
v-robertq-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi, deb_power123 

According to your description and sample data, I think that you can just simply use the “Filter data” function in the Power Query to prevent the rows with blank value in the [Floor] column to be imported into the Power BI, like this:

 

And you can get what you want, like this:

 

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • deb_power123's avatar
    deb_power123
    Icon for Helper V rankHelper V
    5 years ago

    Thankyou 🙂