Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |