Forum Discussion
Lookup with date between multiple date ranges
Hi, I'm running an email campaign analysis and need to lookup a date within a date range and then return the earliest value associated to it (otherwise there are multiple values and I get blank v...
If you unpovited your first table
| Email Campaign | Date | |
| A | start date | 14-Oct |
| A | end date | 21-Oct |
| B | start date | 26-Oct |
etc.
Then you could just get the MIN() start date associated with the campaign
rather than having to do multiple passes seeing which start/end date groups your order date fit into
I'm a personal Power BI trainer I learn something every time I answer a question
Thanks sir, so how would the lookup now work if I unpivot the table?
Which formula would I need to use to check if an order falls between the start and end date of a campaign?