Forum Discussion

JJbc23's avatar
JJbc23
New Member
2 years ago
Solved

date: expiry, plan date conditional formatting

Hi,

 

Would like to seek help on condidtional formatting. 
I have a table with two fields, expiry date and planned date(the date to perform the renewal). 
Would like to have a conditional formatting of, 
if planned date is greater than today and expiry date is greater than today, mark the cell red

Thanks

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi JJbc23 

     

    Based on your needs, I have created the following table.

     

    You can use the following dax to decide if you want to display it in red.

    Highlight = IF(AND('Table'[plan date] > TODAY(), 'Table'[end date] > TODAY()), "True", "False")

     

    Then apply the appropriate rule to this column in the formatting

     

     

     

     

     

    Best Regards,

    Jayleny

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi JJbc23 

     

    Based on your needs, I have created the following table.

     

    You can use the following dax to decide if you want to display it in red.

    Highlight = IF(AND('Table'[plan date] > TODAY(), 'Table'[end date] > TODAY()), "True", "False")

     

    Then apply the appropriate rule to this column in the formatting

     

     

     

     

     

    Best Regards,

    Jayleny

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.