Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 supplies", and "handling"
Thanks in advance! 🙂
Solved! Go to Solution.
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 #], ", " ) )
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
change following in your formula after summarize:
Filter('Purchase Order History',
Not(
'Purchase Order History'[Part Number]
in {
"Shipping Supplier",
"Shop Supplies",
"Office Supplies",
"Handling
}
)
)
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
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 😞
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@parry2k done deal 🙂 Thanks for helping me out!
SUMMARIZE PO =
SUMMARIZE (
'PURCHASE ORDER HISTORY',
'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 #], ", " )
)
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 #], ", " ) )
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
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 #], ", " ) )
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
User | Count |
---|---|
93 | |
83 | |
77 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |