Forum Discussion

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

    Hi Dangar, 

     

    It is giving me this error 

     

     

    • Dangar332's avatar
      Dangar332
      Icon for Resident Rockstar rankResident Rockstar
      1 year 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
        1 year ago

        Hi Dangar, 

         

        It is showing blank