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!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
90 | |
89 | |
79 | |
70 | |
68 |
User | Count |
---|---|
226 | |
129 | |
119 | |
84 | |
77 |