Previous Month Calculation

[IfaZ_1]

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

[v-tangjie-msft]

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. 

[Dangar332]

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.

[IfaZ_1]

Hi Dangar, 

It is giving me this error 

[Dangar332]

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
    )

[IfaZ_1]

Hi Dangar, 

It is showing blank

[Irwan]

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.

[IfaZ_1]

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

[some_bih]

Hi @IfaZ_1 share measure definition for  [Total Tickets]

[IfaZ_1]

here is my measure for

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