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 :

NAMESURNAME
JohnDoe
John Maclane
MaryPoppins

 

The second one have on the first colunn liste of date create by calendar function et other column will be creatte dynamically with the name of the first table like this : 

dateDoeMaclanepoppinsetc...etc...
24/06/2021..............

 

I have see we can create row dynamically but I don't know (Or don't see) if it's possible on this way.

 

Thank you for your help

regards

Need Help

8 Replies

    • dorsey's avatar
      dorsey
      Regular Visitor
      5 years ago

      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  :

      NAMESURNAME
      JohnDoe
      John Maclane
      MaryPoppins

       

      but the second one need reppeat the date any time there is user on the first table : 

      DATE||NAME||SURNAME
      01/01/2021JohnDoe
      01/01/2021John Maclane
      01/01/2021MaryPoppins
      02/01/2021JohnDoe
      02/01/2021John Maclane
      03/01/2021JohnDoe
      03/01/2021......
      • v-kelly-msft's avatar
        v-kelly-msft
        Community Support
        5 years ago

        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,
        Kelly

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

  • 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!