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.
Hi I have a query where I am tying to compare and assign RAG status for any 3 months values in a rolling 6 months period. For example If the % is less than 75% then assign RED etc.
Example data:
Date | Value | Target % |
01/10/2023 | 6027 | 50.23% |
01/11/2023 | 8950 | 74.58% |
01/12/2023 | 8500 | 70.83% |
01/01/2024 | 11500 | 95.83% |
01/02/2024 | 4931 | 41.09% |
01/03/2024 | 5629 | 46.91% |
Solved! Go to Solution.
do you mean mark the number in red?
i think conditional formatting can work for that.
Proud to be a Super User!
Here is a workaround for you, you can create columns to find out the percentage that you need to mark.
Proud to be a Super User!
@ryan_mayu Thanks for your response. I understand the conditional format but what the query should look for if the value is less than 75% for any 3 months of the rolling 6 months then apply conditional format
Here is a workaround for you, you can create columns to find out the percentage that you need to mark.
Proud to be a Super User!
do you mean mark the number in red?
i think conditional formatting can work for that.
Proud to be a Super User!
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
84 | |
66 |