Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Conditional Formatting for a date based on another date

Hello,   I need a way to highlight a date in a table based on it being before or after the first date. All the data comes from project.   Task finish date   task baseline date 18/01/2022        ...
Need Help
  • parry2k's avatar
    parry2k
    5 years ago

    Anonymous ask your boss to give the requirement in one go, or hire som consultant/training for you 🙂

     

    Color = 
VAR __finishDate = MAX ( Highlight[Finish Date] )
VAR __baseDate = MAX ( Highlight[Base Date] )
VAR __days =  DATEDIFF ( __finishDate, __baseDate, DAY )
RETURN

SWITCH ( TRUE(),

    __days > 60, "Green",
    __days > 0, "Orange",
    "Red"
)

     

    Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

    ⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

parry2k's avatar
parry2k
Super User
5 years ago

Anonymous what is the first date? Your example is not clear. are you saying if the finish date is before the baseline date then highlight it in green?

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Yes sorry the task finish date is the first date. If it is before the baseline date make it green, if it's after make it red.

 

Thanks