MY23 and MY22 DAX query

[Anonymous]

Hello, 

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

[aj1973]

Hi @Anonymous 

To compare Data from Year to Year, it is recommended to add a DATE_TABLE, join it to your Master table and then use Time Intelligence functions. 

[Anonymous]

Hey we have already an existing time table but when importing multiple years of data the DAX query is not able to get both years.

Current Market Year = IF('Market Year Dates'[Current Month]>=10,'Market Year Dates'[Current Year]+1,'Market Year Dates'[Current Year])

This DAX query is not working with the previous year data and NEW data coming in. 

[aj1973]

Not sure what you want to achieve but you need to use TI functions to get to compare data, like SAMEPERIODLASTYEAR() or DATE ADD()...

Maybe if you share your PBIX I can be more helpful.

[Anonymous]

hello 

Here is the problem MY23 data is showing up with the below DAX Query but MY22 data is not showing up.

Current Market Year = IF('Market Year Dates'[Current Month]>=10,'Market Year Dates'[Current Year]+1,'Market Year Dates'[Current Year]) 

MY23MY22