Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |