Forum Discussion
Solved
Getting Column from another table by applying filter
Hello everyone, I have the following query: I have table A and table B. Between tables A and B, I have a common field as a key, called Camp_ID. Table A is my main data table. From table B, I ...
Harvey85 , new column in table A
Maxx(filter(TableB, Tablea[Camp_id] = tableB[campId] && containsstring(TableB[categoty], "Spring") ), TableB[Date])
Harvey85 , I suggest that you use Power Query to merge Table A and Table B, and then add the required columns from Table B using the Expand Columns function. This way, you will not need to include Table B in the model, as it is only necessary for obtaining the desired field.
https://learn.microsoft.com/en-us/power-query/merge-queries-overview