Forum Discussion
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 formatt...
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.
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.