Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors