Forum Discussion
SAMEPERIODLASTYEAR not working
Hi
I have an issue with the function SAMEPERIODLASTYEAR
I have reduced my dataset to the minimum to clear all potential inteferences but still
My measure :
But the outcome is the following one :
Thanks for your help
Matt
MKBE , Seems strange
Make sure Year in visual is coming from DimDate
DimDate is Marked as Date Table
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5bd4
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.
2 Replies
MKBE , Seems strange
Make sure Year in visual is coming from DimDate
DimDate is Marked as Date Table
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5bd4
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.Hi,
Indeed after defining the table as Date Table in the model it worked
Thanks for your help
Matt
