cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Vrto95
Helper I
Helper I

join two tables into one

Hi everyone.

I have one question and I hope you can help me.

I have two matric tables.
First of them show information for Current fiscal year and second shows information for prior fiscal year.

 

 

img 1.PNGI want to create third matric table wiche one will show current and prior year information together and also I want to create measure to show current and prior years variance%

 

 

Final result should be this.
How I can implement this?


pic2.PNG

 

 

 

 

 

 

 

 

 

Thanks

1 ACCEPTED SOLUTION

@Tahreem24 , thanks for your helping, I just change my sql, and it's worked 

View solution in original post

8 REPLIES 8
Tahreem24
Super User
Super User

Hi @Vrto95,

 

After merging Current Year and Previous Year table I got the same expected result as per your screen shot given.

if I answered your doubt so Please mark my answer as a solution 🙂 .

 

Sol3.PNG

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , and Fortune 500 Companies Analysis
Tahreem24
Super User
Super User

Hi @Vrto95 ,

 

You can join your current year and prior year table with the help of "Merge Queries" option in Query Editor based on you common column (for example: product name) and then create the variance column like normal calculated column.

 

I tried to replicate your question to some extent and see the expected result. See below steps in screen shot.Sol.PNG

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , and Fortune 500 Companies Analysis

Hi @Tahreem24

My two tables are in same query. Can you show implementation dax process?

Please eleborate more so that I can help you.

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , and Fortune 500 Companies Analysis

My date table is from another query and my product group, Current year and prior year are from another query. How can I merge them,
It will be helpful if you show me steps via screenshots
Thanks

 

Sure,  but if you give me structure of table and sources of those table so I will probably help you.

Actually as per your question I have replicated the scenario in my system and put current and prior year table in two different table then marged them into single table and found the variance.

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , and Fortune 500 Companies Analysis

@Tahreem24 , thanks for your helping, I just change my sql, and it's worked 

Hi @Vrto95 ,

 

Great! 


If my answer helps your question, so please mark it as a solution!

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , and Fortune 500 Companies Analysis

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!