Skip to main content
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

New Member

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.



Incident NumberDateProblemIndex
INC11/1/2022PRB A1
INC21/2/2022PRB A2
INC31/3/2022PRB A3
INC41/4/2022PRB B1
INC51/5/2022PRB B2
INC61/6/2022PRB B3
INC71/6/2022PRB C1
INC81/7/2022PRB D1


Expected Result:

Incident NumberDateProblemIndexPrevious Incident Date
INC11/1/2022PRB A1 
INC21/2/2022PRB A21/1/2022
INC31/3/2022PRB A31/2/2022
INC41/14/2022PRB B1 
INC51/15/2022PRB B21/14/2022
INC61/16/2022PRB B31/15/2022
INC71/16/2022PRB C1 
INC81/17/2022PRB D1 


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

Super User
Super User

@LFORS , Create a new column


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

View solution in original post

Super User
Super User

@LFORS , Create a new column


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

@amitchandak Thanks so much. Worked Perfectly.

Helpful resources

Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.