How to compare date columns from two different tables RRS feed

  • Question

  • Hi 

    I have three tables in my tabular model. (Table A, Table B, Table C)

    I have to compare two date columns from two different tables (Table A and Table B which are not related) and create a derived column which shows "OK" if both dates are equal.  

    There is no relationship between these two tables, but these two are related to another table (Table C - Fact Table).

    I tried to use RELATED dax function in creating the derived column but it is giving me the below error

    =IF(Table A[Date1]<=RELATED(Table B[Date 2]),"OK")

     The column '' either doesn't exist or doesn't have a relationship to any table available in the current context.

    How to solve this issue...

    Thanks in advance

    Monday, July 15, 2019 10:56 PM

All replies