Forum Discussion

Alta88's avatar
Alta88
Icon for Helper IV rankHelper IV
2 years ago
Solved

Creating a Measure for time values

We keep metrics on our daily calls and I'm looking for a way to flag and conditional format calls with a Speed-to-answer (STA) time that exceeds 15 seconds. How would I do this in Dax? 

 

 

Need Help
  • Kaviraj11's avatar
    Kaviraj11
    2 years ago

    Ok, just make sure to format it to date and then it should work.

3 Replies

  • Kaviraj11's avatar
    Kaviraj11
    Icon for Solution Sage rankSolution Sage
    2 years ago

    Firstly, you can create a calculated column:

     

    Flag = SWITCH(TRUE(),'Table'[Time]>TIME(0,0,15),"Yes","No")
     
    And use the above column in conditional format 'Rules' and in Rules if value is = Yes.
  • Alta88's avatar
    Alta88
    Icon for Helper IV rankHelper IV
    2 years ago

    Thank you, Kaviraj11! Looks like the system is flagging an error because I have a discrepancy in the data type (text vs. date) and the formula.

    • Kaviraj11's avatar
      Kaviraj11
      Icon for Solution Sage rankSolution Sage
      2 years ago

      Ok, just make sure to format it to date and then it should work.