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.
|Incident Number||Date||Problem||Index||Previous Incident Date|
|INC1||1/1/2022||PRB A||1|| |
|INC4||1/14/2022||PRB B||1|| |
|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