Forum Discussion

a68tbird's avatar
a68tbird
Icon for Resolver II rankResolver II
8 years ago

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...
Need Help
a68tbird's avatar
a68tbird
Icon for Resolver II rankResolver II
8 years ago

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?

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

Hi,

 

Try this calculated column formula

 

=CALCULATE(MIN(Data[Blocks[AvailabilityEndUtc]]]),FILTER(Data,Data[Campaigns[CampaignName]]]=EARLIER(Data[Campaigns[CampaignName]]])))

 

Hope this helps.