mardi 18 février 2020

Assign value if column is in list (power bi, dax)

I imported a table into Power BI that looks as follows:

  id  value
  01    123
  02    456
  03    789
  04    999

I want to declare a new column called KIND using and IF statement. Something along the lines of:

KIND = if(id is in ("01", "02", "22", "89"), "baker", "other").

The desired result looks as follows:

  id  value   KIND
  01    123  baker
  02    456  baker
  03    789  other
  04    999  other

Aucun commentaire:

Enregistrer un commentaire