Forum Discussion

esammann's avatar
esammann
New Member
7 years ago
Solved

Conditional Formatting on Calculated Date

Hello,   I am trying to highlight certifications that will expire in the next 30 days.  In my data I have an expiration date on the certification.  Once I got the data in I couldn't find a way to d...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi esammann,

     

    Please create such a measure:

    flag = DATEDIFF(TODAY(),SELECTEDVALUE(Table1[Expiration Date]),DAY)

    Then, set conditional formatting for certifications as below:

     

    Best regards,

    Yuliana Gu

  • esammann's avatar
    esammann
    7 years ago

    Hello Yuliana,

     

    Thank  you for the reply.  I managed to get it going a different way though.  After parsing apart the days portion of the date I highlighted the DaysRemaining column, clicked the Transform tab, and then under Data Type I selected Whole Number.  Now the formatting works because before it was being seen as text.

     

    Thanks again!

    Eric

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
7 years ago

Hi esammann,

 

Please create such a measure:

flag = DATEDIFF(TODAY(),SELECTEDVALUE(Table1[Expiration Date]),DAY)

Then, set conditional formatting for certifications as below:

 

Best regards,

Yuliana Gu

  • esammann's avatar
    esammann
    New Member
    7 years ago

    Hello Yuliana,

     

    Thank  you for the reply.  I managed to get it going a different way though.  After parsing apart the days portion of the date I highlighted the DaysRemaining column, clicked the Transform tab, and then under Data Type I selected Whole Number.  Now the formatting works because before it was being seen as text.

     

    Thanks again!

    Eric