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.
Hi everybody,
I'm trying to determine a new column based on information of multiple lines from another table.
I really do not know how to do that and would appreciate your help.
You'll find an image to show what I expect.
In green -> 'Fixe' when all the lines for the 'Paquet' in column 'Longueur' are the same
In blue ->'Variable' when all the lines for the 'Paquet' in column 'Longueur' are not the same
Thanks for your help.
Solved! Go to Solution.
Hey @Anonymous ,
If you just need to fill the second table type and that the first column is created with the differents paquet use :
Hey @Anonymous ,
If you just need to fill the second table type and that the first column is created with the differents paquet use :
@Anonymous , Try like a new column in Table 1
maxx(filter(Table2, Table1[Paquet] = Table2[Paquet]), Table2[Type])
refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8
User | Count |
---|---|
86 | |
82 | |
68 | |
66 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |