Forum Discussion

Starstorm's avatar
Starstorm
Frequent Visitor
4 years ago
Solved

Need Help With Dataset With A Mapping Table To Create New Columns

Hi,   Basically, I am trying to map the "Mapping Table" to my "Primary Data".   Here are the dummy data to illustrate the logic intended. As you can see, the columns highlighted in grey are the v...
Need Help
Show and Tell
Tips and Tricks
  • johnt75's avatar
    johnt75
    4 years ago

    I think you can create a column in both tables like

    Mapping Column = IF ( 'Table'[Account number] = "99999", 'Table'[Account number],
COMBINEVALUES( "|", 'Table'[Account number], 'Table'[Brand], 'Table'[Product])
)

    where 'Table' would be the table you are creating the column in. You should then be able to create a one-to-many relationship from your mapping table to your primary data

johnt75's avatar
johnt75
Super User
4 years ago

I think you can create a column in both tables like

Mapping Column = IF ( 'Table'[Account number] = "99999", 'Table'[Account number],
COMBINEVALUES( "|", 'Table'[Account number], 'Table'[Brand], 'Table'[Product])
)

where 'Table' would be the table you are creating the column in. You should then be able to create a one-to-many relationship from your mapping table to your primary data