SAMEPERIODLASTYEAR or DATEADD not working with calendar which includes hours

[Anonymous]

Hi, 

I have a calendar that includes hours and there is a relationship between the DateTime column and a datetime column in my fact table. When trying to calculate previous years values, the functions SAMEPERIODLASTYEAR or DATEADD don't give any values, which probably is caused by the duplicate dates in the calendar? How should I write a measure to obtain previous years values in this case?

[Anonymous]

Hi, thanks a lot. I got the result I needed using the TI hard way approach.

Br,Christ

[Greg_Deckler · Accepted solution]

@Anonymous You may find this helpful - https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000

Also, see if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TITHW/m-p/434008