Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Dax - Conditional Fomatting

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?

 

  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Greg, the rule would be:

    IF (Duration (Days) > Average of Duration (Days), "Red", "Green")

4 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Greg, the rule would be:

      IF (Duration (Days) > Average of Duration (Days), "Red", "Green")