Forum Discussion
Solved
comparing negative values in DAX
I'm trying to calculate KPI's in PowerBi. For example we have tickets associated with a Time to resolved being 29m (Actual data) and some other tickets that have a value of -2h 30m. I'm trying to fin...
Try:
1) As a calculated column:
meets kpi = IF(CONTAINSSTRING(Table[TTR H:M], "-"), "Not meet", "Meet")
2) As a measure:
meets kpi = IF(CONTAINSSTRING(MAX(Table[TTR H:M]), "-"), "Not meet", "Meet")
Try:
1) As a calculated column:
meets kpi = IF(CONTAINSSTRING(Table[TTR H:M], "-"), "Not meet", "Meet")
2) As a measure:
meets kpi = IF(CONTAINSSTRING(MAX(Table[TTR H:M]), "-"), "Not meet", "Meet")
PaulDBrown it worked perfectly as a Measure!!! Thank you very much for the support!!!!
