SQL Lag to DAX measure

[CaveOfWonders]

Hi All,

Could someone please help me recreate the below SQL into a DAX measure.

The SQL is returning the previous Actual Date from the previous ReportingDate Partitioned by the ProjectID and ProjectMilestoneID.

SELECT 
  P.ProjectID,
  P.Actual,
  P.ReportingDate,
  P.ProjectMilestoneID,
  LAG(P.Actual) OVER (
    PARTITION BY P.ProjectID, P.ProjectMilestoneID
    ORDER BY P.ReportingDate
  ) AS PreviousActual
FROM Project AS P

 Here is the Output in SQL. I've highlighted one example at the bottom where project ID = 181 and Project Milestone ID = 3 it pulls back the previous actual date based on the previous reporting date

Sample Table:

ProjectID ActualDate ReportingDate Project Milestone ID

182	19-May-22	02-Mar-23	1
181	08-Mar-23	02-Mar-23	1
181	01-Mar-23	23-Feb-23	1
182	19-May-22	23-Feb-23	1
181	01-Mar-23	16-Feb-23	1
182	19-May-22	16-Feb-23	1
182	19-May-22	09-Feb-23	1
181	16-Feb-23	09-Feb-23	1
181	16-Feb-23	02-Feb-23	1
182	19-May-22	02-Feb-23	1
181	09-Feb-23	26-Jan-23	1
182	19-May-22	26-Jan-23	1
181	03-May-23	02-Mar-23	2
182	02-Jun-22	02-Mar-23	2
182	28-Apr-22	23-Feb-23	2
181	06-Mar-23	23-Feb-23	2
182	28-Apr-22	16-Feb-23	2
181	06-Mar-23	16-Feb-23	2
181	21-Feb-23	09-Feb-23	2
182	28-Apr-22	09-Feb-23	2
181	21-Feb-23	02-Feb-23	2
182	28-Apr-22	02-Feb-23	2
182	28-Apr-22	26-Jan-23	2
181	14-Feb-23	26-Jan-23	2
181		02-Mar-23	3
182		02-Mar-23	3
182	02-Jun-22	23-Feb-23	3
181	29-Mar-23	23-Feb-23	3
182	02-Jun-22	16-Feb-23	3
181	29-Mar-23	16-Feb-23	3
182	02-Jun-22	09-Feb-23	3
181	16-Mar-23	09-Feb-23	3
182	02-Jun-22	02-Feb-23	3
181	16-Mar-23	02-Feb-23	3
181	09-Mar-23	26-Jan-23	3
182	02-Jun-22	26-Jan-23	3

[Tahreem24]

@CaveOfWonders Try to use OFFSET and INDEX dax.