Forum Discussion
create column dynamically from other table
dorsey , it is better to unpivot the second table in power query and get first name. Then you can create a common first name column
Hey !
Thank you for your answer, it's working perfectly and I think it will be very usefull.
But finaly, my problème is unsolved, my fault of course because it's a logical problem.
I need to find if my user have check this day or not, and I think finaly I need to combinate two table.
the first one don't change but the seconde one need to create the row dynamicaly.
I explain :
the first one is always :
| NAME | SURNAME |
| John | Doe |
| John | Maclane |
| Mary | Poppins |
but the second one need reppeat the date any time there is user on the first table :
| DATE | ||NAME | ||SURNAME |
| 01/01/2021 | John | Doe |
| 01/01/2021 | John | Maclane |
| 01/01/2021 | Mary | Poppins |
| 02/01/2021 | John | Doe |
| 02/01/2021 | John | Maclane |
| 03/01/2021 | John | Doe |
| 03/01/2021 | ... | ... |
Hi dorsey,
For rows 2021/2/1,why there are only 2 rows?Shouldnt there be 3 rows,which is same as 2021/1/1?
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
Hi,
Thank you for reply.
Not really because it's a table for the holiday who user have take. For exemple the 2021/1/1, three persons have take the day but the day after only two
regards.
Hi dorsey ,
Then how to check how many people take the day?Could you show more sample data with expected output to make the logic clear？
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
