Forum Discussion

heathernicole's avatar
heathernicole
Continued Contributor
9 years ago
Solved

Comparing dates from two different tables in a related table

I have three tables:

1. - Expected Date

2. Ship Date

3. Order Table

 

 

 

The order table has relationships with the Expected Date Calendar table and the Ship Date Table. I've put the columns I need in a matrix.

 

 

I am wanting to compare the Due Date (in WVL) column to the Ship Date column. If the Due Date column is > than the Ship Date Column, Not ok, OK.

 

It SEEMS like it would be a simple IF function - but it won't reference the columns properly. I've tried using the RELATED function - says it needs to be a fully qualified column. Any ideas of how to make this work properly?

 

Thanks in advance! 

 

NOTE: the relationship between the orders table and the two different dates table - is based off a date id for each table. the orders table has a shipdateid column and a expecteddateid column. Many to one, I believe. 

  • dkay84_PowerBI's avatar
    dkay84_PowerBI
    9 years ago

    May seem trivial but you are in fact making a calculated column and not a measure?

4 Replies

  • dkay84_PowerBI's avatar
    dkay84_PowerBI
    Microsoft Employee

    What DAX formula did you use for your custom column?  Did you use the TableName[ColumnName] syntax?

    • heathernicole's avatar
      heathernicole
      Continued Contributor

      dkay84_PowerBI - Hey! :) I did - 

       

      I did a basic IF formula to start IF('Expected Date'[Due Date (in WVL)] > 'Ship Date'[Ship Date], "Not ok", "ok")

      • dkay84_PowerBI's avatar
        dkay84_PowerBI
        Microsoft Employee

        May seem trivial but you are in fact making a calculated column and not a measure?