Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Solved! Go to 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])
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] ) )
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])
User | Count |
---|---|
82 | |
80 | |
71 | |
71 | |
55 |
User | Count |
---|---|
108 | |
108 | |
97 | |
86 | |
68 |