Lookup - Interval - Periodes of dates

[nankerp]

I have two two tables (main and lookup) and want to get a value (task) from the lookuptable depending on product and date.

I was thinking of using Power Query or datamodel.

Any suggestion for how to solve this problem.

Description of the problem

[AlB]

Hi  @nankerp

What is end of period? End of the year?

If so, try this for your column in DAX, where Table2 is your Lookup table:

NewColumnTask =
LOOKUPVALUE (
    Table2[Task],
    Table2[Product], MainTable[Product],
    Table2[Date], ENDOFYEAR ( MainTable[Date] )
)

[nankerp · Accepted solution]

I think I found a solution. Maybe not the most sexy one but it work.

SELECTCOLUMNS(
   topn(1;FILTER(factArbOppg;
    factArbOppg[Lisens]=EARLIER(factOverdragelse[Lisens])
    && factArbOppg[Frist]>=EARLIER(factOverdragelse[Dato])
    );
   factArbOppg[Frist];
   ASC);
  "NewColumn";factArbOppg[Oppgavenavn])