Adding column to DAX table with new values from another table

[Anonymous]

Hello,

I need your support for the following issue please. I created a DAX table (Table B) starting from (Table A), in order to have the most recent audit date by company, by audit type, by status.

After getting the (table B), i want to add for each line, the corresponding value from (table A) column (Score).  

Please see below example.

Thanks for your support.

[v-lionel-msft]

Hi @Anonymous ,

Please refer to my .pbix file.

Column = 
LOOKUPVALUE(
    'table A'[Score],
    'table A'[Company], 'Table'[Company],
    'table A'[Date], 'Table'[Date],
    'table A'[Status], 'Table'[Status],
    'table A'[type], 'Table'[type]
)

.PBIX FILE 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , refer if this can help

https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/

[Daviejoe]

Does this help?

https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?GroupId=547&MessageK...