Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Change and output string value in a table

Hi all,   Is there away to trim or change a string from an array and only output particular terms.   For example, from the table below, I only want to output the string values of 'Owners' and 'Me...
"DAX"
DAX ALL PowerBI Excel
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
3 years ago

Hi,

The below is one of many solutions to create a new table.

Please check the below picture and the attached pbix file.

 

 

 

 

Create New Table =
SELECTCOLUMNS (
    ADDCOLUMNS (
        Data,
        "@MembershipNew",
            SWITCH (
                TRUE (),
                CONTAINSSTRING ( Data[Membership], "Owners" ), "Owners",
                CONTAINSSTRING ( Data[Membership], "Members" ), "Members"
            )
    ),
    "@Group", Data[Group],
    "@Membership", [@MembershipNew]
)