Solved: Switch True Calculated Column formula

Anonymous · ‎11-10-2021

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 · ‎11-10-2021

@Anonymous So...

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

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

Greg_Deckler · ‎11-10-2021

@Anonymous So...

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

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...