Forum Discussion

Sander_NL's avatar
Sander_NL
Icon for Helper I rankHelper I
4 years ago
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...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Sander_NL ,

    Try a new column =

    var _cnt = calculate(distinctcount(Table[Status]), filter(table, [app] = earlier([app]) ) )

    return

    if(_cnt=1, "OK", "NOK")

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Sander_NL ,

Try a new column =

var _cnt = calculate(distinctcount(Table[Status]), filter(table, [app] = earlier([app]) ) )

return

if(_cnt=1, "OK", "NOK")

 

Sander_NL's avatar
Sander_NL
Icon for Helper I rankHelper I
4 years ago

Thanks a lot!