Forum Discussion
Helper IIIFind the matching date
Hi ask,
You can add calculate column with minx function to get the specific event date, below is the sample:
Logic: get all "event date" which large the current date, use minx function to get the min date.
Event = MINX(FILTER(ALL('Event'),Event[Event Date]>=EARLIER('Date'[Date])),[Event Date])Diff = DATEDIFF([Date],[Event],DAY)
Regards,
Xiaoxin Sheng
Helper IIIwaiting .............
can anyone help me out?
- ask
I have 2 tables, one event table, another table containing the date as well. I need to find the matching date from event date. For example, 5/18/2017, I need to add 5/27/2017 from Event table, and calculate how many tables from event date. I have the output table attached as well. Any advice?
Event Date 4/29/2017 5/6/2017 5/27/2017 Date 5/18/2017 5/17/2017 5/16/2017 5/15/2017 5/15/2017 5/14/2017 5/6/2017 5/5/2017 5/4/2017 5/3/2017 5/2/2017 5/1/2017 4/30/2017 4/29/2017 4/28/2017 4/27/2017 Output will look like the table below
Date Event Date Days 5/18/2017 5/27/2017 -9 5/17/2017 5/27/2017 -10 5/16/2017 5/27/2017 -11 5/15/2017 5/27/2017 -12 5/15/2017 5/27/2017 -12 5/14/2017 5/27/2017 -13 5/6/2017 5/6/2017 0 5/5/2017 5/6/2017 -1 5/4/2017 5/6/2017 -2 5/3/2017 5/6/2017 -3 5/2/2017 5/6/2017 -4 5/1/2017 5/6/2017 -5 4/30/2017 5/6/2017 -6 4/29/2017 4/29/2017 0 4/28/2017 4/29/2017 -1 4/27/2017 4/29/2017 -2 Hi ask,
You can add calculate column with minx function to get the specific event date, below is the sample:
Logic: get all "event date" which large the current date, use minx function to get the min date.
Event = MINX(FILTER(ALL('Event'),Event[Event Date]>=EARLIER('Date'[Date])),[Event Date])Diff = DATEDIFF([Date],[Event],DAY)
Regards,
Xiaoxin Sheng
- ask
Thank you Anonymous. Super helpful