how to shift row values to next row

[Uzi2019]

Hi Community,

I have two column one is date another is values. I have tried a lot many approaches but not getting any complete result. 

So basicaly, value should be shifted to next row as per date and if same date is repeated so same values should be there. If i am not clear so below is the expected ouput.

I tired this below DAX not getting 100% result:

output = CALCULATE(MAX(tbl[Values]),FILTER(tbl,tbl[Index]=EARLIER(tbl[Index])-1))

Input is like below: 

Date    Values
1/1/2020    138
1/1/2020    124
1/2/2020    120
1/3/2020    80
1/3/2020    100
1/4/2020    90
1/5/2020    110

Expected Output:

Date        Values    Output
1/1/2020    138    138
1/1/2020    124    124
1/2/2020    120    124
1/3/2020    80    80
1/3/2020    100    100
1/4/2020    90    100
1/5/2020    110    90

TIA!

[Uzi2019]

Can anybody help me out in this. It's little urgent.

[Tahreem24 · Accepted solution]

@Uzi2019 ,

First, create Index column from Query editor and then try below DAX column:

Output =

VAR A = MIN('TABLE'[Date])

RETURN IF('TABLE'[Date]=A,('TABLE'[Values]),LOOKUPVALUE('TABLE'[Values],'TABLE'[Index],'TABLE'[Index]-1))

[Uzi2019]

@Tahreem24 

Thank you for your reply.. solution is working perfectly for me.. thank you for your time.