Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Is this what you are looking for?
@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
)
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.
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |