Can't use date hierarchy after a SAMEPERIODLASTYEAR in a measure

[DiMar]

I don't get it, I'm becoming crazy. I have a 2 very simple measures

nb customer = SUM(DATA[nb])

nb customer Y-1  = CALCULATE(SUM(DATA[nb]), SAMEPERIODLASTYEAR(REF_DATE[date]))

Everything works fine for the 1st measure, I can use date hierarchy or not in a 2 dimension table.

Everthing works fine for the 2nd measure when I don't use date hierarchy. And nothing works when I try to use date hierarchy.

 

Plain white, no data relative to the date, while I know the formula works because I get the correct reply when I don't use date hierarchy. Can someone help me finding what is wrong here???

[Greg_Deckler · Accepted solution]

@DiMar 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-TIT...