ifs(in([Agency Name], Database[Agency Name]), any(select(Database[Agency Phone Number], [Row ID] = maxrow("Database", "_RowNumber", [_THISROW].[Agency Name]=[Agency Name]))))
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter