Calculated Column

[Himanshu_1306]

Hi All,

I'm trying to create a calculated column for Current Quarter from my Date column but its giving me incorrect data.

Any help where I'm going wrong?

I have the below tables in my dataset which I can use.

I'm trying to make a column like below but its not giving me correct value

IsCurrentQuarter =

    IF (

        YEAR ( ACV[CLOSE_DATE] ) = YEAR ( TODAY () )

            && QUARTER(ACV[CLOSE_DATE] ) = QUARTER( TODAY()),

        "Yes",

        "No"

    )

Regards,

Himanshu

[amitchandak · Accepted solution]

@Himanshu_1306 , Seem fine, Try like

Switch( True() ,

format(today(), "YYYY - \QQ") = format([Date], "YYYY - \QQ"), "This Qtr",

[Qtr Year]

)