Switch True Calculated Column formula

[Anonymous]

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
)

[Greg_Deckler · Accepted solution]

@Anonymous  So...

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