Forum Discussion
Using DAX to Filter a Table for a Status Column
Hi all, I've trying to create a Status column based on whether the 'Difference From Target' column is positive or negative using this DAX as a measure: Status = IF([Difference From Target] >...
Anonymous , Try like
Status = Switch(true(),
isblank([Difference From Target]), Blank() ,
[Difference From Target] > 0, "Green"
, "Red")
Anonymous , Try like
Status = Switch(true(),
isblank([Difference From Target]), Blank() ,
[Difference From Target] > 0, "Green"
, "Red")
Worked perfectly! Thanks so much! Subscribed to your channel 🙂