I need to unite the values of fields of type text in two different tables, how can I do?
Solved! Go to Solution.
To connect my divisions, I use this. I wanted to share them with you.
Well it depends. Are the tables related? Are you writing a measure or a calc column? Why do you want to do this - IE what are you trying to achieve and why?
If these two tables are related, you can use LOOKUPVALUE() function to import the expected column into current table based on the related column. And concatenate it with existing column.
Then involve this calculated column in your measure.
LOOKUPVALUE Function (DAX)
Ok, you assuming you are writing a measure over your data table, you can use the RELATED() function to do what you want. https://msdn.microsoft.com/en-us/library/ee634202.aspx
If you are writing a measure over a lookup table, there is a RELATEDTABLE function, but this may be an issue as it will return multiple rows of data.
Click here to learn more about the August 2022 updates!
Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.