Forum Discussion
Finding Earliest Date Among Common Entries
Hello All, I have a situation where I would like to find the earliest date related to a group of entries. Here's the setup: Campaigns[CampaignName] Blocks[DateVenue] Blocks[Availability...
Ashish_Mathur I have reformated the data and should be easily pasted into Excel.
Anonymous Thanks for the suggestion, but not working for me. Please note that I have two joined tables here: Campaigns and Blocks. If I try that formula you suggested, the intellisense doesn't give me the choices of columns to make it work. Any suggestions on how to amend that formula to take this into account?
Hi,
Try this calculated column formula
=CALCULATE(MIN(Data[Blocks[AvailabilityEndUtc]]]),FILTER(Data,Data[Campaigns[CampaignName]]]=EARLIER(Data[Campaigns[CampaignName]]])))
Hope this helps.