DAX Calculation - previous rows value bought into current row

[databot_kd]

Hi community, 

How can i bring the previous rows value into the current row?
 

HC Latest Mon/Yr measure:

CALCULATE(COUNT('Headcount Details'[Position]),

                    MAXX(

                    KEEPFILTERS(VALUES('Headcount Details'[YearD])),

                    CALCULATE(MAX('Headcount Details'[Month]))

                ) = 'Headcount Details'[Month])

Used to get the count of position for the max month month in the year. 

Thanks in advance

[Ahmedx]

pls try this

Measure= 
CALCULATE(
[HC Latest Mon/Yr], 
   OFFSET(-1,SUMMARIZE(ALLSELECTED('Headcount Details),'Headcount Details'[YearD],'Headcount Details'[MaxCurrentMonthYear]),ORDERBY('Headcount Details'[YearD]))
)

[databot_kd]

Thanks @Ahmedx for responding. 

MaxCurrentMonthYear is also a measure 

MAXX(

                    KEEPFILTERS(VALUES('Headcount Details'[YearD])),

                    CALCULATE(MAX('Headcount Details'[Month]))

                )

it wont seem to work with SUMMARIZE

[Ahmedx]

try this

Measure= 
CALCULATE(
[HC Latest Mon/Yr], 
   OFFSET(-1,SUMMARIZE(ALLSELECTED('Headcount Details),'Headcount Details'[YearD]),ORDERBY('Headcount Details'[YearD]))
)

[databot_kd]

Unfortunately, still no luck. 

Below is the error 

YearD is a calculated column:
YearD = YEAR(date column) 

[Ahmedx · Accepted solution]

you forgot the bracket for ALLSELECTED('Headcount Details)

-----------------

Measure=
CALCULATE(
[HC Latest Mon/Yr],
OFFSET(-1,SUMMARIZE(ALLSELECTED('Headcount Details),'Headcount Details'[YearD]),ORDERBY('Headcount Details'[YearD]))
)

[databot_kd]

Thank you. That worked now 🙂