The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.