cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Vrto95 Regular Visitor
Regular Visitor

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

Accepted Solutions
Vrto95 Regular Visitor
Regular Visitor

Re: join two tables into one

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

View solution in original post

8 REPLIES 8
Tahreem24 Member
Member

Re: join two tables into one

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

 

Tahreem24 Member
Member

Re: join two tables into one

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

Vrto95 Regular Visitor
Regular Visitor

Re: join two tables into one

Hi @Tahreem24

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

Tahreem24 Member
Member

Re: join two tables into one

Please eleborate more so that I can help you.

Vrto95 Regular Visitor
Regular Visitor

Re: join two tables into one

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

 

Tahreem24 Member
Member

Re: join two tables into one

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.

Vrto95 Regular Visitor
Regular Visitor

Re: join two tables into one

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

View solution in original post

Tahreem24 Member
Member

Re: join two tables into one

Hi @Vrto95 ,

 

Great! 


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

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 256 members 2,811 guests
Please welcome our newest community members: