Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
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 Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous , refer if this can help
https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/
Does this help?
Proud to be a Super User!
User | Count |
---|---|
96 | |
87 | |
78 | |
72 | |
68 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |