Issue with Switch statement

[Anonymous]

Hi,

Im writing a column that would look something like this:

Age Buckets = SWITCH(TRUE(),

DATESBETWEEN('SP Fit/Gap'[Modified Date],today()-15,today()), " 1-15",

DATESBETWEEN('SP Fit/Gap'[Modified Date],today()-30,today()-15),"15-30",

DATESBETWEEN('SP Fit/Gap'[Modified Date],today()-60,today()-30),"30-60"

)

But this gives me an error: Switch does not support the value of type True False with values of type date

How to resolve this?

[DataInsights · Accepted solution]

@Anonymous,

Try this calculated column:

Age Buckets = 
VAR vModDate = 'SP Fit/Gap'[Modified Date]
VAR vToday =
    TODAY ()
VAR vResult =
    SWITCH (
        TRUE (),
        vModDate >= vToday - 15
            && vModDate <= vToday, "1-15",
        vModDate >= vToday - 30
            && vModDate <= vToday - 16, "16-30",
        vModDate >= vToday - 60
            && vModDate <= vToday - 31, "31-60"
    )
RETURN
    vResult