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.
Hi,
In colum1 I want to delete rows with text 'Ending Balance for Period' and 'GL JE Name' how would I do this?
Many thanks
Solved! Go to Solution.
Just filter them out. The logic here is you won't technically be removing them, but you'll be selecting all rows that don't have that text.
It will generate code similar to this:
=Table.SelectRows(#"Changed Type", each not Text.Contains([ID], "Ending Balance for Period") and not Text.Contains([ID], "GL JE Name"))
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingJust filter them out. The logic here is you won't technically be removing them, but you'll be selecting all rows that don't have that text.
It will generate code similar to this:
=Table.SelectRows(#"Changed Type", each not Text.Contains([ID], "Ending Balance for Period") and not Text.Contains([ID], "GL JE Name"))
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingThank you again for the support
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.
User | Count |
---|---|
99 | |
50 | |
19 | |
12 | |
11 |