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

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.

  • v-kelly-msft's avatar
    v-kelly-msft
    Community Support
    5 years ago

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

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