Sum + DatesInPeriod didn't work.

[Amymai]

Hi guys,

I tried to show 3 previous months from the selected month using DatesInPeriod function but it didn't work well. 

My measure is: 

Total Stock Value last 3 month =
CALCULATE(
Sum('KPI[$ Value SOH]),

DATESINPERIOD('Date'[Date],MAX('Date'[Date]),-3, MONTH))

I guess the issue comes from the data but I can't figure out what's wrong with it. Please help!!

Here is pbix file

https://drive.google.com/file/d/1x2h4RrPpWnOOKAQUXcDNgH2Lng6iXlbK/view?usp=sharing

Thank you!

[v-chuncz-msft]

@Amymai,

The values in [$ Value SOH] are the same.

[Greg_Deckler]

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...

[Amymai]

Thank you! But I don't think that can be work. I've tried my measure to another database and it's ok. The problem here is I don't understand what's wrong with this data.