Forum Discussion

bbelman's avatar
bbelman
New Member
5 years ago
Solved

In DAX formula, Conditionally Concatenate value from another table

I am trying to use a DAX forumla to create a new table that requires me to reference existing data (which will be the rows in the table) and I also need to reference other existing data in order to c...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    5 years ago

    @bbelman You can create a new table with the following measure:

    Table 2 =
VAR __table =
    ADDCOLUMNS (
        'Primary Table',
        "combine",
            IF (
                RELATED ( 'Secondary Table'[rate] ) <> 1,
                'Primary Table'[summary] & " - " & RELATED ( 'Secondary Table'[descripton] ),
                'Primary Table'[summary]
            )
    )
RETURN
    SELECTCOLUMNS ( __table, "id", [id], "summary", [combine] )

    v-jingzhang_0-1602036197985.png

v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity Support
5 years ago

@bbelman You can create a new table with the following measure:

Table 2 =
VAR __table =
    ADDCOLUMNS (
        'Primary Table',
        "combine",
            IF (
                RELATED ( 'Secondary Table'[rate] ) <> 1,
                'Primary Table'[summary] & " - " & RELATED ( 'Secondary Table'[descripton] ),
                'Primary Table'[summary]
            )
    )
RETURN
    SELECTCOLUMNS ( __table, "id", [id], "summary", [combine] )

v-jingzhang_0-1602036197985.png

  • bbelman's avatar
    bbelman
    New Member
    5 years ago

    Worked perfectly. Thank you! I expect the other posted solution provided will also work but performing the action in a measure as opposed to a calcualted column provides better proformance by keeping the dataset lean.