how to get value for previous month in looker studio?

I have a field in my data that represents number of employees in the end of the month (called ending headcount) and also its month year. i want to make a calculated fields that will count number of employees in the beginning of the month which has the same value as ending headcount in the previous month . For example: number of employees in the beginning of the month February = ending headcount on january 

how to write the formula for count number of employees in the beginning of the month (same as ending headcount for previous month) in calculated field on looker studio?

Attached the data looks like this. 

brndp_0-1696492549424.png

 

 

0 0 2,496
0 REPLIES 0
Top Labels in this Space
Top Solution Authors