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

[mjg30aus]

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?

[Anonymous · Accepted solution]

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.

[lbendlin]

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

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/1447...