topic Re: DAX: Calculate sum of previous quarter in DAX Commands and Tips

DAX: Calculate sum of previous quarter

PakAli — Mon, 15 Jul 2024 02:04:55 GMT

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

Re: DAX: Calculate sum of previous quarter

Jihwan_Kim — Mon, 15 Jul 2024 02:44:27 GMT

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.

Re: DAX: Calculate sum of previous quarter

PakAli — Mon, 15 Jul 2024 03:52:50 GMT

Interesting..

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

Re: DAX: Calculate sum of previous quarter

Jihwan_Kim — Mon, 15 Jul 2024 18:35:27 GMT

Hi,

can you please share how your visualization is built?

Re: DAX: Calculate sum of previous quarter

PakAli — Tue, 16 Jul 2024 02:05:48 GMT

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

stupid me, hahahaha

TQTQTQ for your guidance..