Forum Discussion
Solved
Need Help with Dax
Having three tables, Table A is a one-to-many relationship to Table B and Table B is a one-to-many relationship to Table C, and I would like to get a calculated column "value" in the form of Result d...
Hi JMJM,
With your mock data this calculated column in Table A will probably do the job:
Value = CALCULATE ( MAX ( 'Table C'[Value] ) )But one to many means that you can have 2 entries in Table C with Activity ID = 0003 and values 300 and 400. Which value do you expect to receive as a result?
Best Regards,
Alexander
barritown
Solution Sage
Solution SageHi JMJM,
With your mock data this calculated column in Table A will probably do the job:
Value = CALCULATE ( MAX ( 'Table C'[Value] ) )But one to many means that you can have 2 entries in Table C with Activity ID = 0003 and values 300 and 400. Which value do you expect to receive as a result?
Best Regards,
Alexander