Add Column to Dataset From Another Dataset

[walla386]

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!

[Anonymous]

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

[amitchandak]

@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])