Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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] >...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , Try like

     

    Status = Switch(true(),
    isblank([Difference From Target]), Blank() ,
    [Difference From Target] > 0, "Green"
    , "Red")

Anonymous's avatar
Anonymous
Not applicable
3 years ago

please help me to make table with target amitchandak