cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

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 ITIL you can have multiple incidents with the same root cause and they are grouped at a problem level (Many:1). I have created an index in DAX that displays the sequence in which that incident occurs i.e first is 1 second is 2 etc and will reset for each problem.

Data:

 Incident Number Date Problem Index INC1 1/1/2022 PRB A 1 INC2 1/2/2022 PRB A 2 INC3 1/3/2022 PRB A 3 INC4 1/4/2022 PRB B 1 INC5 1/5/2022 PRB B 2 INC6 1/6/2022 PRB B 3 INC7 1/6/2022 PRB C 1 INC8 1/7/2022 PRB D 1

Expected Result:

 Incident Number Date Problem Index Previous Incident Date INC1 1/1/2022 PRB A 1 INC2 1/2/2022 PRB A 2 1/1/2022 INC3 1/3/2022 PRB A 3 1/2/2022 INC4 1/14/2022 PRB B 1 INC5 1/15/2022 PRB B 2 1/14/2022 INC6 1/16/2022 PRB B 3 1/15/2022 INC7 1/16/2022 PRB C 1 INC8 1/17/2022 PRB D 1

I have found this post but doesnt work for what i need it to do.

Any help would be greatly appreciated as i have been struggling with this for the past month. Thanks

1 ACCEPTED SOLUTION
Super User

@LFORS , Create a new column

maxx(filter(Table, [problem] = earlier([problem]) && [date] < earlier([Date]) ) , [Date])

2 REPLIES 2
Super User

@LFORS , Create a new column

maxx(filter(Table, [problem] = earlier([problem]) && [date] < earlier([Date]) ) , [Date])

Frequent Visitor

@amitchandak Thanks so much. Worked Perfectly.

Announcements

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.