topic Re: Usage for Origional Product then wish to find the Total new Price if Alternative Product Purchased in DAX Commands and Tips

Usage for Origional Product then wish to find the Total new Price if Alternative Product Purchased

mjg30aus — Mon, 09 Sep 2024 04:29:49 GMT

Hi there New to this

I have a catalouge with the same products data duplicated but called Catalogue and Switch Catalogue

I have the spend data for my customer but i want to create

The Origional Product Code with the Usage and Total Spend (Easy Done)

Then a matched alternative code with each price but to calculate the Spend Based on the Orional Product Usage but with the new Product Sell Price?

The i want to see the Difference between Old Code Total Sales and New Product Total Sales, and then have the Table Totals to be correct with this new Column?

Re: Usage for Origional Product then wish to find the Total new Price if Alternative Product Purchased

lbendlin — Mon, 09 Sep 2024 12:31:23 GMT

Sounds good. What have you tried and where are you stuck?

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Re: Usage for Origional Product then wish to find the Total new Price if Alternative Product Purchased

Anonymous — Wed, 25 Sep 2024 08:07:35 GMT

Hi mjg30aus

Based on your needs, I have created the following table.

You can use the following dax to get the result you want:

Category Cost = [Catalogue Price]*[Usage]

Switch Category Cost = [Switch Catalogue Price]*[Usage]

Difference = SUM('Table'[Switch Category Cost])-SUM('Table'[Category Cost])

Result:

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.