Forum Discussion
Solved
Display previous incident date for each problem (DAX)
Hi all, Im new to this forum but would love it if someone could help me with a DAX question? What i am trying to achieve is display the date of the previous incident at a problem level. So in...
LFORS , Create a new column
maxx(filter(Table, [problem] = earlier([problem]) && [date] < earlier([Date]) ) , [Date])
LFORS , Create a new column
maxx(filter(Table, [problem] = earlier([problem]) && [date] < earlier([Date]) ) , [Date])
amitchandak Thanks so much. Worked Perfectly.