Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
siroopm2020
Helper I
Helper I

Find differences of total of two table.

I'm a newbie in Power Bi.

I have 2 price tables in Excel.

I want the price difference of these tables in Powerbi.

Please help me to do this. 

 

Table 2021
Item CodeUSDEURCADJPY
872903561823.2215.753
872903641114.199.6252
12548965810.3271
125489734861.92427
884612895672.24498
8846129745.163.59
8846130585109.6574.37512
Total230.00296.70201.2541.19

 

Table 2020
Item CodeUSDEURCADJPY
8729035616.120.814.12.3
872903649.912.78.61.4
125489657.29.36.31.0
1254897343.155.537.76.2
8846128950.264.844.07.2
884612973.64.63.17.9
8846130576.298.466.710.9
Total206.31266.14180.5236.95

 

Result (Total Difference)
USD23.7
EUR30.6
CAD20.7
JPY4.2
1 ACCEPTED SOLUTION
Jihwan_Kim
Super User
Super User

Hi, @siroopm2020 

Please check the below picture and the sample pbix file's link down below.

I suggest having table structures like below.

 

Picture3.png

 

 

https://www.dropbox.com/s/4rx229f089se1dm/siroopm.pbix?dl=0 

 

 

Hi, My name is Jihwan Kim.

 

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

 

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Go to My LinkedIn Page


View solution in original post

5 REPLIES 5
siroopm2020
Helper I
Helper I

Thank You. Both replies are useful. Problem solved. 

Jihwan_Kim
Super User
Super User

Hi, @siroopm2020 

Please check the below picture and the sample pbix file's link down below.

I suggest having table structures like below.

 

Picture3.png

 

 

https://www.dropbox.com/s/4rx229f089se1dm/siroopm.pbix?dl=0 

 

 

Hi, My name is Jihwan Kim.

 

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

 

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Go to My LinkedIn Page


kindly explain to me how did you create a table structure like this from the given data 

Hi, @siroopm2020 

Thank you for your feedback.

I did the transform of each table in Power Query Editor.

You can select the Item Code Column, and unpivot others.

 

Thank you.

 

Hi, My name is Jihwan Kim.

 

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

 

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Go to My LinkedIn Page


amitchandak
Super User
Super User

@siroopm2020 , one way is have measure like

USD diff = sum(Table2021[USD])  -sum(Table2020[USD]) 

 

EUR diff = sum(Table2021[EUR])  -sum(Table2020[EUR]) 

 

Then you can use show on row in matrix visual and use only values (put thisnew measure in values)

 

Or

Unpivot two Table - https://radacad.com/pivot-and-unpivot-with-power-bi

 

Create Currency bridge table

Bridge Table: https://www.youtube.com/watch?v=Bkf35Roman8&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=19

 

 

then create a measure and analyze by currency

sum(Table2021[Value])  -sum(Table2020[Value]) 

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.