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
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
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.
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
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.
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.
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
hello
Here is the problem MY23 data is showing up with the below DAX Query but MY22 data is not showing up.
MY23
MY22
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
123 | |
74 | |
66 | |
53 | |
53 |
User | Count |
---|---|
199 | |
104 | |
88 | |
79 | |
77 |