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.
Hello people,
I have doubts about how to create a dax function that changes only with month \ year, to highlight in the table only the tickets that were above the average month \ year.
In this screen printed below, the month of March had three tickets resolved that totaled 25.95 days and an average of 8.65 days per ticket.
In the table, only the 1st ticket lasting 12.21 days should be colored.
Is there a way to do this?
Solved! Go to Solution.
Hi Greg, the rule would be:
IF (Duration (Days) > Average of Duration (Days), "Red", "Green")
So what is the rule that it should be highlighted?
Hi Greg, the rule would be:
IF (Duration (Days) > Average of Duration (Days), "Red", "Green")
Hi there.
Here's your solution. Please adjust it to your needs.
Here's the file:
https://1drv.ms/u/s!ApyQEauTSLtOgYM_8lY01MNux79mvw?e=LOxfiX
Best
D
Thank you very much @Anonymous,
That was exactly what I was needing.
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |