Forum Discussion
Solved
Delete rows containing certain text
Hi all, I have the above information already in POWER BI. I need to know how I can eliminate the rows in the Part Number column that contain "shipping supplies", "shop supplies, ", "office ...
SUMMARIZE PO = SUMMARIZE ( Filter('Purchase Order History', Not( 'Purchase Order History'[Part Number] in { "Shipping Supplier", "Shop Supplies", "Office Supplies", "Handling" } ) ) , 'PURCHASE ORDER HISTORY'[Part Number], "TOTAL COST", SUM ( 'PURCHASE ORDER HISTORY'[PN Total Cost] ), "Quantity Ordered", SUM ( 'PURCHASE ORDER HISTORY'[Qty Ordered] ), "PO list", CONCATENATEX ( 'PURCHASE ORDER HISTORY', 'PURCHASE ORDER HISTORY'[Purchase Order #], ", " ) )
just the bracket after summarize , replace 'Purchase Order History' with my formula then comma and continue on.
If you past your formula as text i will update it, because you pasted image and i'm lazy to type all your formula in there :(