Find latest incident

[mitieterry]

Hi all - apologies if this is a repeat of another post, but I cannot seem to find the same problem.

I have two tables, one of which lists all locations within the business (site details), and another that lists all incidents reported from sites (incidents). I am looking for a way to add a lookup in the site details table which returns the date of the latest incident reported for each location - or blank if none reported.

both tables have a column called store number which is a unique reference for the location.

Any assistance would be greatly appreciated.

[v-jiascu-msft · Accepted solution]

Hi @mitieterry,

It's a good idea to share a sample. Maybe you can try this formula.

Column =
CALCULATE ( MAX ( TheOtherTable[Date] ) )

Best Regards!

Dale

[Ashish_Mathur]

Hi,

Share the link from where i can download your file.

[rocky09]

First create realtionship between two tables with the store number (should be unique values). Once you create realtionship. You can now, use Max function to get the latest value.