Same Period last year not working when I select up to today in date slicer

[ravi_ch]

Hi,

Same Period working fine but it when i selected up to today date in date slicer it is taking one year extra for calculation

Today is April 12 2022

If I select Upto today it is taking upto 3/30/2023

can someone help me with this?

Thank you

[v-xiaotang]

Hi @ravi_ch 

I just want to confirm if you resolved this issue? If yes, you can accept the answer helpful as the solution or share you method and accept it as solution, thanks for your contribution to improve Power BI.

If you need more help, please let me know.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@ravi_ch , Hope you are using date table.

Date in slicer and visual is from date table

Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),SAMEPERIODLASTYEAR('Date'[Date]))

Today's date will show a year behind 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-bd52912a5b...
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.