Forum Discussion

walla386's avatar
walla386
Helper I
5 years ago

Add Column to Dataset From Another Dataset

Hello,

 

I have two datasets that share some common variables. I'd like to add a column from one of the datasets to the other dataset by using a shared value. What's the best way to do this??

 

Thanks!

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    walla386 , refer if these can help

    Copy data from one table to another - with related, without related
    Item Name = RELATED('item'[Brand])
    Copy City without using related
    City Name = maxx(FILTER(geography,geography[City Id]=Sales[City Id]),geography[City])

     

    Month Name = LOOKUPVALUE('date'[Month Year],'date'[Date],Sales[Sales Date])

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi walla386 ,

    Could you please provide some sample data(exclude sensitive data) and your expected result? Please mark the fields which have common variables. By the way, the data is from different table in different dataset?

    Best Regards

    Rena