Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I'm trying to remove "OrderId" rows from all the tables in my query. Each table has repeating headers throughout. I've promoted the top header, and removed all blanks. But I can't find a way to filter all the tables so "OrderID" doesn't repeat all through my query. Thanks
Solved! Go to Solution.
Hi @michaelmichael ,
Table.SelectRows should help you in your scenario.
Okay - Sorted it.
I just expanded columns on the final table, and then filtered out the repeated data. Rookie error
Thanks for your help.
Hi @michaelmichael ,
Table.SelectRows should help you in your scenario.
@v-frfei-msft Hi, I've tried SelectRows
= Table.SelectRows([Remove Blanks],####)
But in the #### I can't select the Column [OrderId] I want to filter
Okay - Sorted it.
I just expanded columns on the final table, and then filtered out the repeated data. Rookie error
Thanks for your help.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.