Forum Discussion
Dax
I have an issue: I have: 1. IDs (this contains nvarchar ID) 2. Stage (This is the stage of each ID at different dates) 3. Import_Date: This is a date value for all ID. I want to create dax me...
Jay12 , Based on what I got a new column
Next =
var _min = minx(filter(Table , [ID] = earlier([ID]) && [Import Date] > earlier([Import Date]) ), [Import Date])
return
minx(filter(Table , [ID] = earlier([ID]) && [Import Date] =_min ), [Stage])
previous=
var _max = maxx(filter(Table , [ID] = earlier([ID]) && [Import Date] < earlier([Import Date]) ), [Import Date])
return
minx(filter(Table , [ID] = earlier([ID]) && [Import Date] =_max ), [Stage])
Power BI DAX- Earlier, I should have known Earlier: https://youtu.be/CVW6YwvHHi8