Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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])
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
98 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |