Forum Discussion

dirkkoch's avatar
dirkkoch
Helper III
4 years ago
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...
Need Help
Tips and Tricks
Samarth_18's avatar
Samarth_18
Community Champion
4 years ago

Hi dirkkoch ,

 

Create a column with this code:-

Column =
CALCULATE (
    MAX ( 'Table B'[Date] ),
    FILTER ( 'Table B', 'Table B'[Value] = 'Table A'[Value] ),
    USERELATIONSHIP ( 'Table A'[Value], 'Table B'[Value] )
)

Output:-

 

Thanks,

Samarth

dirkkoch's avatar
dirkkoch
Helper III
4 years ago

Samarth_18 thank you, we are getting closer to a solution. Most of the dates are returned correctly, but still some blanks are left, although the values appear in both tables and a date would be expected. But the rest of the dates are correct.

  • Samarth_18's avatar
    Samarth_18
    Community Champion
    4 years ago

    dirkkoch Is it possible for you to share PBIX file after removing sesitive data?

    In the mean time you can try below code:-

    Column =
CALCULATE (
    MAX ( 'Table B'[Date] ),
    FILTER ( 'Table B', TRIM ( 'Table B'[Value] ) = TRIM ( 'Table A'[Value] ) ),
    USERELATIONSHIP ( 'Table A'[Value], 'Table B'[Value] )
)