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