Forum Discussion

sahmad's avatar
sahmad
New Member
4 years ago
Solved

Many to Many relation applied on grid

Task

TaskId

TaskNameTask Date
1Morning Walk20/05/2022
2Breakfast20/05/2022

 

Task Assingee

TaskIdResourceIdIsAssigneeIsOwener
11truetrue
12truefalse

 

Resource

ResourceIdResourceName
1AB
2XY

 

Now I need to show the data in grid like the following table

TaskIdTaskNameTaskDateAssigneeOwners 
1MorningWalk20/05/2022AB,XYAB 
      

 

Also Need to add Slicer for Resources to fitler out the data

Tables are well defined and has well joined to each other based on pk->Fk .. In other word, it many to many relation, but unfortunatly, i could find any tutorial/videos or any description to show the data in grid. And more, having above structure, i am unable to apply slicer (resource) on chart having drill down option set with some category and sub category, and then count of Tasks...

Any one can please explain, how to achieve above.. More i have applied group by ,but could not filter out with (assingee/owner) option

Need Help
  • v-zhangti's avatar
    v-zhangti
    4 years ago

    Hi, sahmad 

     

    Please check the following methods.

    Column:

    Assignee = 
CONCATENATEX (
    'Task Assingee',
    IF (
        [IsAssignee] = TRUE,
        LOOKUPVALUE ( Resource[ResourceName], Resource[ResourceId], [ResourceId] ),
        BLANK ()
    ),
    ","
)
    Owener = 
IF (
    [IsOwener] = TRUE,
    LOOKUPVALUE ( Resource[ResourceName], Resource[ResourceId], [ResourceId] ),
    BLANK ()
)

    Is this the result you expect?

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

2 Replies

  • v-zhangti's avatar
    v-zhangti
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi, sahmad 

     

    Please check the following methods.

    Column:

    Assignee = 
CONCATENATEX (
    'Task Assingee',
    IF (
        [IsAssignee] = TRUE,
        LOOKUPVALUE ( Resource[ResourceName], Resource[ResourceId], [ResourceId] ),
        BLANK ()
    ),
    ","
)
    Owener = 
IF (
    [IsOwener] = TRUE,
    LOOKUPVALUE ( Resource[ResourceName], Resource[ResourceId], [ResourceId] ),
    BLANK ()
)

    Is this the result you expect?

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    • sahmad's avatar
      sahmad
      New Member
      4 years ago

      Yeah, Thanks a lot, Thats what i was looking for