Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Switch True Calculated Column formula

Hi Experts

The below calculated column measure is in one column in the second column i would like to show 1 as Red in text and 2 as Amber and 3 as Green as text in a new Column called RAG

Date Period = 
SWITCH (
    TRUE(),
    [Date] < TODAY(), 1,
    [Date] <= EOMONTH ( TODAY(), 0 ), 2,
    3
)

 

Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    4 years ago

    Anonymous  So...

    RAG = 
SWITCH (
    TRUE(),
    [Date] < TODAY(), "Red",
    [Date] <= EOMONTH ( TODAY(), 0 ), "Amber",
    "Green"
)

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    4 years ago

    Anonymous  So...

    RAG = 
SWITCH (
    TRUE(),
    [Date] < TODAY(), "Red",
    [Date] <= EOMONTH ( TODAY(), 0 ), "Amber",
    "Green"
)