Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
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 🙂 .
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.
Hi @Tahreem24
My two tables are in same query. Can you show implementation dax process?
Please eleborate more so that I can help you.
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.
Hi @Anonymous ,
Great!
If my answer helps your question, so please mark it as a solution!
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |