Forum Discussion

Alta88's avatar
Alta88
Helper 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.

Alta88's avatar
Alta88
Helper 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
Solution Sage
2 years ago

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