Forum Discussion

heathernicole's avatar
heathernicole
Icon for Continued Contributor rankContinued 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 ...
  • 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?

dkay84_PowerBI's avatar
dkay84_PowerBI
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

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

heathernicole's avatar
heathernicole
Icon for Continued Contributor rankContinued Contributor
9 years ago

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
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

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

    • heathernicole's avatar
      heathernicole
      Icon for Continued Contributor rankContinued Contributor
      9 years ago

      Perfect!! :) I thought I had tried the column but apparently, I had tested the measure and not created a calculated column. That did it!

       

      Thanks so much! 

       

       

      THANK YOU!!!!