topic Re: Previous Month Calculation in DAX Commands and Tips

Previous Month Calculation

IfaZ_1 — Mon, 09 Sep 2024 03:53:11 GMT

Hi,

I'm running a the end of blocked road here. I have tried several times and still my calculation didnt appear.

this is the calculation I made :

MoM Total Ticket =

CALCULATE(

[Total Tickets],

PREVIOUSMONTH('FY Date'[Date])

)

The result and my relationship tables

Re: Previous Month Calculation

some_bih — Mon, 09 Sep 2024 05:28:45 GMT

Hi IfaZ_1 share measure definition for [Total Tickets]

Re: Previous Month Calculation

IfaZ_1 — Mon, 09 Sep 2024 05:47:47 GMT

here is my measure for

Total Tickets = SUM('Page 1'[DNME]) + SUM('Page 1'[SLAEE]) + SUM('Page 1'[Open]) + SUM('Page 1'[SLAME])

Re: Previous Month Calculation

Dangar332 — Mon, 09 Sep 2024 05:50:51 GMT

HI, IfaZ_1

Try below measure

MoM Total Ticket = var previous_month = maxx( filter( all('FY Date'[Month]), 'FY Date'[Month]<min('FY Date'[Month]) )) return CALCULATE( [Total Tickets], 'FY Date'[Month]=previous_month )

Best Regards,
Dangar

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Previous Month Calculation

IfaZ_1 — Mon, 09 Sep 2024 06:12:46 GMT

Hi Dangar,

It is giving me this error

Re: Previous Month Calculation

Dangar332 — Mon, 09 Sep 2024 06:27:38 GMT

MoM Total Ticket = var previous_month = maxx( filter( all('FY Date'[Month]), 'FY Date'[Month]<min('FY Date'[Month]) ),'FY Date'[Month]) return CALCULATE( [Total Tickets], 'FY Date'[Month]=previous_month )

Re: Previous Month Calculation

IfaZ_1 — Mon, 09 Sep 2024 06:41:19 GMT

Hi Dangar,

It is showing blank

Re: Previous Month Calculation

Irwan — Tue, 10 Sep 2024 03:47:52 GMT

hello IfaZ_1

i downloaded your sample file in your other post couple days ago.

i was meant to ask you, is there any reason you collect month from 'Page 1' tbl?

if you take month value from 'FY Date' tbl, you can see the result already.

for your record, i didnt change any DAX, only change month value from 'Page 1' tbl to 'FY Date' tbl.

MoM SLA or MoM Totak Ticket use time intellegence value from 'FY Date' tbl so it might be the issue why it shows no value (i am not sure on this, but it does show the previous value).

Hope this will help.
Thank you.

Re: Previous Month Calculation

Anonymous — Tue, 10 Sep 2024 08:51:36 GMT

Hi IfaZ_1 ,

Thanks to Irwan , Dangar332 and some_bih for their quick replies. I have some other thoughts to add:

(1) We can create a column on [FY Date] table.

Month_num = MONTH([Date])

(2) We can create a measure.

MoM Total Ticket = CALCULATE( [Total Tickets], FILTER(ALL('FY Date'),[Month_num]=MAX('FY Date'[Month_num])-1) )

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.

Re: Previous Month Calculation

IfaZ_1 — Fri, 13 Sep 2024 06:35:03 GMT

Because if I use the FY table my tickets number is not the same.