Forum Discussion

dorsey's avatar
dorsey
Regular Visitor
5 years ago

create column dynamically from other table

Hello everyone,   First sorry for my bad english. I'm carry on this powerful software and I've a new question.    To explain my problème, I have 2 tables the first one is like this : NAME ...
Need Help
dorsey's avatar
dorsey
Regular Visitor
5 years ago

Yes of course.

 

This my first table : 

On the second one, on all day find who is missing (something like that) :

DATE||NAME||SURNAME
01/01/2021JohnRambo
01/01/2021John otherone
.........
02/08/2021doegregoire
02/08/2021doesbérengère
02/08/2021mclanegregory
02/08/2021poppinssheryl
03/08/2021......
v-kelly-msft's avatar
v-kelly-msft
Community Support
5 years ago

Hi  dorsey ,

 

So you wanna find the missing people from your first table(you provided in your last reply) and below table?

Then get a final table something like below:

Did I understand correctly?If possible,could you pls share a sample .pbix file for test?

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!