We are getting ready to import MY23 data but we are having an issue with allowing both MY23 DATA to be shown and MY22 data on the same report. The query that was previously written doesn't work with implement MY23 data
MYTD = IF(or(and('Market Year Dates'[Current MY Period]='Market Year Dates'[MY Period],'Market Year Dates'[Day]<'Market Year Dates'[Current Day]),'Market Year Dates'[MY Period]<'Market Year Dates'[Current MY Period]),"Y","N")
Currently I have hardcoded MY as 2022 in order to only pull MY22 data because when we use the QUERY above it does not allow me to filter to MY22 data.
Please let me know if it's possible how to allow end users to filter to MY22 and the new MY23 data.
Thanks in advance