Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
87 | |
72 | |
69 | |
64 | |
55 |
User | Count |
---|---|
99 | |
91 | |
80 | |
74 | |
64 |