Forum Discussion
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?
Ok, just make sure to format it to date and then it should work.
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.