Forum Discussion
Find latest incident
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.
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
3 Replies
- rocky09
Solution Sage
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.
v-jiascu-msftMicrosoft Employee
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
Super User
Hi,
Share the link from where i can download your file.
