Forum Discussion
Need Help Creating Matrix based on Goal v Actual
Hi JP_G ,
You can refer to the following steps:
1. In the power query editor, hold down the CTRL key, select these four columns, and then click the unpivot columns button. Both tables perform the same operation.2. After applying the results to desktop, create a relationship for two tables.
3. Place the appropriate fields in the matrix and rename them in the visual object.
If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi JP_G ,
You can refer to the following steps:
1. In the power query editor, hold down the CTRL key, select these four columns, and then click the unpivot columns button. Both tables perform the same operation.
2. After applying the results to desktop, create a relationship for two tables.
3. Place the appropriate fields in the matrix and rename them in the visual object.
If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Clara,
I will try this and post my progress. Thank you!
JP