Forum Discussion
Solved
Check if multiple rows have same value than status OK else NOK in new column
Good evening, I have a table with the following columns/rows and I'm looking for a way to create the new column overall status. I know how to do a check row by row but now I need to check all the...
Try a new column =
var _cnt = calculate(distinctcount(Table[Status]), filter(table, [app] = earlier([app]) ) )
return
if(_cnt=1, "OK", "NOK")
Try a new column =
var _cnt = calculate(distinctcount(Table[Status]), filter(table, [app] = earlier([app]) ) )
return
if(_cnt=1, "OK", "NOK")
Thanks a lot!