Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Jameswh91
Helper III
Helper III

Best way to get the cost price for bundle products

‎04-03-2022 02:41 PM

Hi I'm looking to get the cost prices for bundle products for our sales data. Unfortunately the list of cost prices i have only show the cost for single items. Is there a dax calculation that can account for the bundle sku code of X2 or X3 to calculate the cost from the single price item?

 

I have attached an image of the data.

 

Capture7.PNG

 

Message 1 of 3
663 Views
0
1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support

‎04-07-2022 08:55 PM

HI @Jameswh91,

You can create a calculated column to multiply the 'unit price' with 'bundle qty' field values to get the total price. If they are not stored in the same table, you can use lookupvalue function to get the bundle qty based on the current 'SKU code'.

LOOKUPVALUE function (DAX) - DAX | Microsoft Docs

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

Message 3 of 3
571 Views
0
2 REPLIES 2
v-shex-msft
Community Support
Community Support

‎04-07-2022 08:55 PM

HI @Jameswh91,

You can create a calculated column to multiply the 'unit price' with 'bundle qty' field values to get the total price. If they are not stored in the same table, you can use lookupvalue function to get the bundle qty based on the current 'SKU code'.

LOOKUPVALUE function (DAX) - DAX | Microsoft Docs

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Message 3 of 3
572 Views
0
Greg_Deckler
Super User
Super User

‎04-03-2022 04:55 PM

@Jameswh91 So what is the logic for that calculation?



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
Message 2 of 3
595 Views
0

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

View All