last month value

[sagaraperera]

dear all

i already get a last year selected month value using given below formula 

sum( {$<YEAR = {"$(=Only([YEAR]-1))"},CLA_CODE= {'M3'}>} [GROSSTOT] )

now i want get a last month value , pls help me

sagara

[MohammedMustaq]

Try this

Last Month:

=Sum({<CLA_CODE= {'M3'},MonthYear={'$(=MonthName(MonthStart(Max(Date))-1))'}>}[GROSSTOT])

make sure you have Monthyear field

Thanks

Mustaq

[Arthur_Fong]

Try this:

sum({<Month={"$(=month(AddMonths(max(<date>),-1,0)))"},<date>=,CLA_CODE= {'M3'}>}  [GROSSTOT])

Replace <date> to your date column in data model.

Be sure you have Month column defined in your data model.

If Month is not defined, refer qvw attached as reference.

Thanks and regards,

Arthur Fong

[Brett_Bleess]

Sagara, did either of the posts get you what you needed?  If so, please be sure to return to the thread and use the Accept as Solution button on the one(s) that did help you get things working.  If you did something else, consider posting that and then mark it, so others will know what actually worked.  If you still need further assistance, please leave an update for us.

Regards,
Brett