how to show previous month joiners?

[Akina0929]

Hi,

I have a table which consist of joining date and no of joiners

I want to show no of joiners in previous month in text box.

[sunny_talwar · Accepted solution]

I guess create a new field called MonthYear from your joining date field like this

Date(MonthStart([joining date), 'MMM-YYYY') as MonthYear

and then use it like this

Sum({<MonthYear = {"=$(=Date(AddMonths(Max(MonthYear), -1), 'MMM-YYYY'))"}>}[no of jiners])