Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Get Value from Table having Implicit Relationship

Hello All,   I have a table with below relationship,     Now here what I want to is add a calculated column in Table A. The formula for Calculated Column in Table A will look something lik...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous , Try like new column 

    if(isblank(countx(filter('Table B','Table A'[DateTime] >= 'Table B'[StartDate] && 'Table A'[DateTime] < 'Table B'[EndDate]),'Table B'[DateKey])),0,1)
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Anonymous , Try like new column 

if(isblank(countx(filter('Table B','Table A'[DateTime] >= 'Table B'[StartDate] && 'Table A'[DateTime] < 'Table B'[EndDate]),'Table B'[DateKey])),0,1)