Forum Discussion

Mallikarjun_P's avatar
Mallikarjun_P
New Member
3 years ago
Solved

Communications dashboard for Department

Hi, I am trying to build a communications dashboard for department where I collect topics under various categories for every month. My table looks something like this   I would like to display ...
General Comment
Need Help
Show and Tell
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Mallikarjun_P ,

     

    I suggest you to create a measure by below code.

    Combine =
VAR _AddCombine =
    ADDCOLUMNS ( 'Table', "Combine", COMBINEVALUES ( " : ", [Topic], [Speaker] ) )
VAR _CONCATENATE =
    CONCATENATEX ( _AddCombine, [Combine], "
" )
RETURN
    _CONCATENATE

    Result is as below.

     

    Best Regards,
    Rico Zhou

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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Mallikarjun_P ,

 

I suggest you to create a measure by below code.

Combine =
VAR _AddCombine =
    ADDCOLUMNS ( 'Table', "Combine", COMBINEVALUES ( " : ", [Topic], [Speaker] ) )
VAR _CONCATENATE =
    CONCATENATEX ( _AddCombine, [Combine], "
" )
RETURN
    _CONCATENATE

Result is as below.

 

Best Regards,
Rico Zhou

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