Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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

  • Anonymous's avatar
    Anonymous
    7 years ago

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