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 have many tables containing equal headers, what I need is to delete the rows when this header is repeated.
In this way I would only have one MAIN header and the others would eliminate them.
The option of filtering and eliminating would not help me because in some cases the header containing the value moves a cell (variable) and that does not remove all the values when filtering because I do not know which column can contain the value to I need to remove I came up with the option of placing a conditional column so that by placing the data to be deleted as an option to filter in that column and knowing which row contains the data to be repeated. Another option that probe but does not work is to use the Table.RemoveMatchingRows function in M, but it does not delete the data that I place as parameters.
Hi @Anonymous
Can you upload sampledata, pbix and output expected to Google/One Drive and share the link here to find a solution.
Cheers
CheenuSing
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 |
---|---|
112 | |
100 | |
77 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |