Calculated Column

[Anonymous]

Hi All,

My calculated column "Previous Month" is not giving the correct value now. Since last week everything was working fine.

I cant see the option "Yes" in the dropdown now.

Is it because of the year condition? If so, what calculation should I use?

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your data model looks like, but please try something like below for creating a new column.

Previous Month CC =
SWITCH (
    TRUE (),
    MONTH ( TODAY () ) <> 1,
        IF (
            YEAR ( AGGR_LAND_EXPAND_VIEW[DATE] ) = YEAR ( TODAY () )
                && AGGR_LAND_EXPAND_VIEW[CALENDAR_MONTH]
                    = MONTH ( TODAY () ) - 1,
            "Yes",
            "No"
        ),
    MONTH ( TODAY () ) = 1,
        IF (
            YEAR ( AGGR_LAND_EXPAND_VIEW[DATE] )
                = YEAR ( TODAY () ) - 1
                && AGGR_LAND_EXPAND_VIEW[CALENDAR_MONTH] = 12,
            "Yes",
            "No"
        )
)

[Anonymous]

Thanks for the help.

It worked for Dec'22 !!!