Forum Discussion
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 19/01/2022
So in this example, task finish date would be green.
Thanks
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.⚡
7 Replies
Anonymous add a measure:
Color = IF ( MAX ( Table[FinishDate] ) < MAX(Table[BaseDate]), "Green", "Red" )Then on Finish Date column, go to conditional formatting, and set the formatting to field value and use above measure.
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.⚡
Thank you very much. Another quick question, my boss has asked for the following:
Within 60 calendar days = Amber
Greater than 60 days = Green
So is it possible to change the formula to reflect those. Essentially if the finish date is up to 60 days before the baseline date it's amber. If it's greater than 60 days it's green and if the finish date is after the baseline date it's red. So he's asked for some additional stuff.
Your help is apprieciated and thank you
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 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.⚡
Anonymous I know but in case if he ever agreed, feel free to reach out since I do training programs. Cheers!!