Forum Discussion

a68tbird's avatar
a68tbird
Resolver 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
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Create a column with this formula:

 

Earliest Article = if(CALCULATE(MIN(Table1[Date]),FILTER(Table1,Table1[Article]= EARLIER(Table1[Article]))) = Table1[Date],"EarliestCapaign")

 

Thanks
Raj