Previous Date

[popo125]

Hello,

I would like to create a New column that will allow me to have the time of the previous validator.

here is the result I would like to have.

in my table there are between 5 and 4 validators (column with number 2) by Excel file (column with number 1).
What I want is that in the line of the validator 2, I can have the time (column with number 3) and the date of validation of the validator 1 of the same excel file).

I don't know if it's ideal to do it in M or in DAX ?

for your information:

• would it be possible not to modify the formatting (no unpivot or transpose transformation).
• validator 1 has no pre-date since it is the creator.

I hope that my request has been well explained and that you could help me please



thanks

 

[alansidman]

Cannot read nor manipulate your data in the picture. Please upload same to thread using XL2BB.