DAX: Calculate sum of previous quarter

[PakAli]

Hi, 
I had search and found several queries on similar topic, 
However, when I tried, I do not achieve what I want
Instead, it is calculating "SUM amount up to the date"
Seeking advice what I did wrong

[PakAli · Accepted solution]

Ohhhh... After observing the result (image), now I do understand

stupid me, hahahaha

TQTQTQ for your guidance.. 

[Jihwan_Kim]

Hi,

I am not sure how your semantic model looks like, but please try having a calendar_dimension table like below.

I tried to create a sample pbix file like below, and please check the below picture and the attached pbix file.

[PakAli]

Interesting..

However, I have a question, 
why it is not working when using the 'date' column in the same table

[Jihwan_Kim]

Hi,

can you please share how your visualization is built?