Expression to show Last Month value

[MPS]

Dear Team,

Am trying to get the last month value to show under KPI title which is taken from the excel file. But now the KPI shows the total from Jan to Dec, wherein I want to show only the last Month data and not sum.

Data is rolling totals

Below is the current expression, and have a variable for previous month.  So can you please help me with the query to show last month value as 3.

current expression --- sum( {<RowType={'Other Activity'},[Other ActivityType]={'Consultant Trainings'}, [_KEY_DATE]={">=$(vYTD_DateFrom) <=$(vYTD_DateTo)"} ,YEAR=,MONTH=,Quarter=>} ActivityValue)

Previous month variable --- vPreviousMonth

Please help 

[agigliotti]

Hi @MPS ,

try this one:

sum(  {< RowType = {'Other Activity'}, [Other ActivityType] = {'Consultant Trainings'},  MONTH={"$(=Month(Today())-1)" } >}  ActivityValue )

Best Regards

[Kushal_Chawda]

@MPS  may be this

sum( {<RowType={'Other Activity'},[Other ActivityType]={'Consultant Trainings'}, [_KEY_DATE]={">=$(=monthstart(max(_KEY_DATE),-1)) <=$(=monthend(max(_KEY_DATE),-1)) "} ,YEAR=,MONTH=,Quarter=>} ActivityValue)

[MPS]

Unfortunately, both expression resulted the values to zero. Not sure if i am missing anything to do.