Forum Discussion

kangu's avatar
kangu
Regular Visitor
4 years ago
Solved

Merger text in tabel

Hello I have data tabel in Power BI   I need to merger (sum) text to have this: I can do it to number, but I can't to text. Please help I need this in tabel visualisation on PowerBI ...
Need Help
  • PaulDBrown's avatar
    PaulDBrown
    4 years ago

    With DAX:

    As a calculated Column (my Table is called 'FTable')

    VALUE =
CONCATENATEX (
    FILTER (
        ALL ( FTable ),
        FTable[ID] = EARLIER ( FTable[ID] )
            && FTable[Type] = EARLIER ( FTable[Type] )
    ),
    FTable[Orig Value],
    ", "
)

     

    As a measure:

    VALUE1 =
VAR _id =
    MAX ( FTable[ID] )
VAR _type =
    MAX ( FTable[Type] )
RETURN
    CONCATENATEX (
        FILTER ( ALL ( FTable ), FTable[ID] = _id && FTable[Type] = _type ),
        FTable[Orig Value],
        ", "
    )

     

    I've attached the sample PBIX file

     

PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
4 years ago

With DAX:

As a calculated Column (my Table is called 'FTable')

VALUE =
CONCATENATEX (
    FILTER (
        ALL ( FTable ),
        FTable[ID] = EARLIER ( FTable[ID] )
            && FTable[Type] = EARLIER ( FTable[Type] )
    ),
    FTable[Orig Value],
    ", "
)

 

As a measure:

VALUE1 =
VAR _id =
    MAX ( FTable[ID] )
VAR _type =
    MAX ( FTable[Type] )
RETURN
    CONCATENATEX (
        FILTER ( ALL ( FTable ), FTable[ID] = _id && FTable[Type] = _type ),
        FTable[Orig Value],
        ", "
    )

 

I've attached the sample PBIX file

 

  • kangu's avatar
    kangu
    Regular Visitor
    4 years ago

    Thanks, it's working ! 🙂