Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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
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
Hi,
Share the link from where i can download your file.
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.
User | Count |
---|---|
93 | |
83 | |
77 | |
74 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |