Forum Discussion

PSB's avatar
PSB
Helper III
3 years ago
Solved

append columns

How can I combine S_Cell1, S_Cell2, S_Cell3 into one column S_Cell1,2,3 and keep the other related column data with it. Example shown below in Before and After  
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    3 years ago

    PSB This is a DAX calculated table. It is probably doable in Power Query as well, but that will take me a minute to figure out. Give me a few minutes.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

PSB Try:

Table 2 = 
FILTER(
    UNION(
        SELECTCOLUMNS('Table',"T_cid",[T_cid],"T_gnb",[T_gnb],"T_nRPCI",[T_nRPCI],"T_nRTAC",[T_nRTAC],"S_Cell1,2,3",[S_Cell1]),
        SELECTCOLUMNS('Table',"T_cid",[T_cid],"T_gnb",[T_gnb],"T_nRPCI",[T_nRPCI],"T_nRTAC",[T_nRTAC],"S_Cell1,2,3",[S_Cell2]),
        SELECTCOLUMNS('Table',"T_cid",[T_cid],"T_gnb",[T_gnb],"T_nRPCI",[T_nRPCI],"T_nRTAC",[T_nRTAC],"S_Cell1,2,3",[S_Cell3])
    ),
    [S_Cell1,2,3] <> BLANK()
)