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 the format 2023Q4, 2023Q3, etc.  I'm trying for something like a calculated column that says:

 

If the 'fiscal year quarter' column matches year and quarter today 1, otherwise 0

 

I just cannot seem to get there on my own.

Need Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper 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.