Forum Discussion

Dev_B_PBIing's avatar
Dev_B_PBIing
Frequent Visitor
3 years ago

Is current quarter flag

I'm having lots of issues omitting current quarter from my visuals.  I'm trying to accomplish this with a flag built from an already existing column called Fiscal year and quarter which has data in t...
Need Help
amitchandak's avatar
amitchandak
Super User
3 years ago

Dev_B_PBIing , Create column in one of the ywo ways

 

Switch( True() ,
format(today(), "YYYY\QQ") = format([Date], "YYYY\QQ"), 1,
0
)

 

 

Or

 

 

Switch( True() ,
format(today(), "YYYY\QQ") = [Year Qtr], 1,
0
)

  • Dev_B_PBIing's avatar
    Dev_B_PBIing
    Frequent Visitor
    3 years ago

     

    amitchandak 

    Using the second option is really close, but it's flagging the wrong quarter.  It flagged 2023 FQ2 aka Calendar quarter, I'm trying to filter to Fiscal Quarter...we're currently in FQ4 until July 2023.

     

    Could a Dateadd +2 somehow be added to this measure to make it work?  Essentially this would always be filtering our current Fiscal quarter.