Forum Discussion
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.
I 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?
Thanks
Tahreem24 , thanks for your helping, I just change my sql, and it's worked
8 Replies
Tahreem24Super User
Hi Anonymous ,
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.
- Tahreem24
Hi Anonymous,
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 :) .