Forum Discussion
Remove rows from data
Hi Anonymous ,
We can use two ways to meet your requirement. One is in Power Query Editor, another is to create a calculate table.
1. In Power Query Editor, we can create a conditional column. The “Total” is 0, others are 1.
2. Then we filter out the value of 0 in custom column.
3. At last we delete the custom column, the result like this,
Or we can create a calculate table using DAX.
Table 2 = SUMMARIZE(FILTER('Table (2)','Table (2)'[ColB]<>"Total"),'Table (2)'[ColA],'Table (2)'[ColB],'Table (2)'[ColC])If them don’t meet your requirement, could you please show the exact expected result based on the table that you have shared?
BTW, pbix as attached.
Best regards,
Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
sorry, obviously did not manage to include a screenshot:
I had earlier tried using this workaround sturlaws, but, this wouldn't work since the column where"Total" appears could be text/date/location and due to presence of "Total" in its values, I am unable to change the datatye of these columns to date. It will always consider it as a text unless we remove the rows containg total.
Your original post did not include that piece of pertinent information 😀
So I altered your sample data a little:
If you click on the Source-step you get the original table. Now filter out the 'Total'-rows and you get this: