Forum Discussion
Adding column to DAX table with new values from another table
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.
3 Replies
v-lionel-msftCommunity Support
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] )Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Daviejoe
Memorable Member
- amitchandak
Super User
Anonymous , refer if this can help
https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/
