Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have data in table visuals below
Town Month Target Sales
A Jan-23 2M 1.5M
A Feb-23 3M 2.2M
A Mar-23 3.5M 3M
I want to add a column with calculating % achievement of sales against the target.
Anyone can help
Hi,
you could just use a calculate sum measure:
User | Count |
---|---|
85 | |
76 | |
73 | |
70 | |
56 |
User | Count |
---|---|
104 | |
99 | |
93 | |
78 | |
69 |