https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Merge-two-cell-value-in-row-to-one-value/m-p/3171156#M114304 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="532852" data-lia-user-login="PoojaS5" class="lia-mention lia-mention-user">PoojaS5</a>&nbsp;</P> <P><img /></P> Tue, 04 Apr 2023 08:42:29 GMT tamerj1 2023-04-04T08:42:29Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Merge-two-cell-value-in-row-to-one-value/m-p/3171077#M114299 <P>Hi ,</P><P>&nbsp;</P><P>so this is the table i'm getting while trying to add data in powerBI</P><P>current output;</P><P><img /></P><P>Desired Output;</P><P><img /></P><P>&nbsp;any solution would be appreciated thanks in advance</P><P>&nbsp;</P> Tue, 04 Apr 2023 08:01:28 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Merge-two-cell-value-in-row-to-one-value/m-p/3171077#M114299 PoojaS5 2023-04-04T08:01:28Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Merge-two-cell-value-in-row-to-one-value/m-p/3171156#M114304 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="532852" data-lia-user-login="PoojaS5" class="lia-mention lia-mention-user">PoojaS5</a>&nbsp;</P> <P><img /></P> Tue, 04 Apr 2023 08:42:29 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Merge-two-cell-value-in-row-to-one-value/m-p/3171156#M114304 tamerj1 2023-04-04T08:42:29Z