How to cal calculate previous month Total

[Amardeep100115]

Please help me to calculate previous month total with currant month and quarter. Please note it needs be calculate as per fiscal year which starts from Oct 2018 . to access data please visit below link https://1drv.ms/u/s!Ai3rGPgy20kLwRZ0Ci5K07f41wSJ?e=KHVKrm

[v-cherch-msft]

Hi @Amardeep100115 

Please use below measure to get the previous month Total.

Measure = 
CALCULATE (
    SUM ( sasw[Total] ),
    FILTER (
        sasw,
        MONTH ( sasw[As of Date] )
            = MONTH ( TODAY () ) - 1
            && YEAR ( sasw[As of Date] ) = YEAR ( TODAY () )
    )
)

Regards,

[Amardeep100115]

Thanks for your response

result should be the total of previous  month, please advice

---

@v-cherch-msft wrote:

Hi @Amardeep100115 

Please use below measure to get the previous month Total.

Measure = 
CALCULATE (
    SUM ( sasw[Total] ),
    FILTER (
        sasw,
        MONTH ( sasw[As of Date] )
            = MONTH ( TODAY () ) - 1
            && YEAR ( sasw[As of Date] ) = YEAR ( TODAY () )
    )
)

Regards,

---

[v-cherch-msft · Accepted solution]

Hi @Amardeep100115 

You may check below measure.Create rank and yearmonth column first.

Measure = 
IF (
    ISFILTERED ( sasw[Month] ),
    CALCULATE (
        SUM ( sasw[Total] ),
        FILTER ( ALL ( sasw ), sasw[Rank] = MAX ( sasw[Rank] ) - 1 )
    ),
    SUM ( sasw[Total] )
)

Regards,

[Amardeep100115]

One more request.

i have added one table in which we i have last 8 month date.

I wish to use filter from FY 2019 table and SASW total need to reflect selected month total + Last month total

please find the belwo file location

https://1drv.ms/u/s!Ai3rGPgy20kLwRdWKMv6sHk5oNQy?e=kxzxY1

[v-cherch-msft]

Hi @Amardeep100115 

I would suggest you create a new thread on forum so that more community members can see it and provide advice. Please remember to post dummy data and desired result.

Regards,

[Amardeep100115]

Hi @v-cherch-msft 

After updating power BI file and above formula is not working properly.

Please suggest