- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Insert New column using values from another column - Power BI Desktop
Hi communuty,
I would need a hand to figure out how to create a new column in an existing table by taking data from another table.
I tried to use the formula :
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@marcomartinetti I hope this helps you!Thank You!!
CREATE Column :
CMP = lookup([VALORENETTOSCHEDA],[Articolo],[K_CodArt])
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
oh wow ok! I had never used this feature.
but this feature is fine even if I have to use a double filter? item code and date? or is it just fine with a filter?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@marcomartinetti Yes , you can use in calculate function then apply filter.
For E.g
CMP = calculate(lookup([VALORENETTOSCHEDA],[Articolo],[K_CodArt]), filter(conditions)).
@marcomartinetti THANK YOU!!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
thank you @Mahesh0016
So, I would like to link to each marketing move a cost that is present in the second table
table 1 table 2
way to merge these two tables would be by making filter for column K_CodArt and K_DataRegistraz of the first table.
the result that I would like to have would be to bring up the VALORENETTOSCHEDA column of the second tables in the first. Such as in the image :
Thank you
Marco
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
