Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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!
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
89 | |
80 | |
60 | |
59 | |
58 |
User | Count |
---|---|
157 | |
118 | |
101 | |
76 | |
68 |