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.
I have been asked to create a matrix that would present the following structure:
Month 1 Month 2 Month 3 Current Month YTD FY
Team
- Agent 1
- Actual
- Target
- Agent 2
- Actual
- Target
How can this be achieved in Power BI?
Thank you
Solved! Go to Solution.
Hi @v-cherch-msft ,
I have went through your solution but unfortunately it does work for me since the new measures should be added only at the end and not to be shown by month for example.
I had accomplished this by creating a calculated table with the structure I want and dynamically assigning the correspondent measures based on the current scope.
Thank you
Regards,
LS
Hi @Anonymous
You may create the matrix like page2.Then create measures to get the YTD... like page 1 in attachment.If you need further help,please share some simplified data sample and expected output.
Regards,
Hi @v-cherch-msft ,
I have went through your solution but unfortunately it does work for me since the new measures should be added only at the end and not to be shown by month for example.
I had accomplished this by creating a calculated table with the structure I want and dynamically assigning the correspondent measures based on the current scope.
Thank you
Regards,
LS
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |