Forum Discussion
Solved
Userelationship with if function
Hi, I have two tables A & B with a many to one relationship. This relationship cannot be activated due to activation with another table C. What I want to do is to create the new column marke...
Hi dirkkoch ,
You could try lookupvalue() function.
https://docs.microsoft.com/en-us/dax/lookupvalue-function-dax
column = lookupvalue('tableB'[date],'tableB'[value],'tableA'[value])
Best Regards,
Jay
dirkkoch Maybe CALCULATE(MAX('Table B'[Date]),USERELATIONSHIP('Table A'[Value],'Table B'[Value]))