Forum Discussion

IfaZ_1's avatar
IfaZ_1
Icon for Helper I rankHelper I
2 years ago

Previous Month Calculation

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(       ...
Dangar332's avatar
Dangar332
Icon for Resident Rockstar rankResident Rockstar
2 years ago

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's avatar
IfaZ_1
Icon for Helper I rankHelper I
2 years ago

Hi Dangar, 

 

It is giving me this error 

 

 

  • Dangar332's avatar
    Dangar332
    Icon for Resident Rockstar rankResident Rockstar
    2 years ago
    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's avatar
      IfaZ_1
      Icon for Helper I rankHelper I
      2 years ago

      Hi Dangar, 

       

      It is showing blank

       

      • Irwan's avatar
        Irwan
        Icon for Super User rankSuper User
        1 year ago

        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.