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 All
the following table is an example of a calculation where i am determing
from there i can
4. create the 3 month average which becomes the "baseline target" for the remaining months of the year
5. minus 5% from the "baseline target" to become a Recalculated target
e.g. if a team's baseline is 100, the target will be 95. If a team is doing 95 or less, that's 100%.
6. calculate actual / target as "% difference"
where i am getting stuck is normalising the data, so i can then actually calculate a true % difference
i am not sure where to get started on how to normalise as 100% or if i can using what i am doing
any help would be appreciated
thanks
Hi, @Anonymous ;
Is your problem solved?? If so, Would you mind accept the helpful replies as solutions? Then we are able to close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @Anonymous ;
I'm a little confused by your logic.I tried the following measures in attachment:
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
110 | |
94 | |
80 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |