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! 🙂
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.
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.
