Forum Discussion

hawkeye159's avatar
hawkeye159
Frequent Visitor
2 years ago
Solved

Conditional formatting using two date columns

Hi all, I'm new here and quite new to Power BI, trying to learn as I go and using forums like this to pick up tips.   But I'm struggling to find a solution that matches my problem.   I have a tab...
  • aduguid's avatar
    aduguid
    2 years ago

    Create a new calculated column or measure

     

    Status = 
IF(
    ISBLANK('Table'[EOT Date]),
    IF('Table'[Target Date] < TODAY(), "Expired", "Not Expired"),
    IF('Table'[EOT Date] < TODAY(), "Expired", "Not Expired")
)

     

     

    Set the rules for the conditional formatting:

    • If Status is "Expired", set the color to red.
    • If Status is "Not Expired", set the color to green.
aduguid's avatar
aduguid
Memorable Member
2 years ago

Create a new calculated column or measure

 

Status = 
IF(
    ISBLANK('Table'[EOT Date]),
    IF('Table'[Target Date] < TODAY(), "Expired", "Not Expired"),
    IF('Table'[EOT Date] < TODAY(), "Expired", "Not Expired")
)

 

 

Set the rules for the conditional formatting:

  • If Status is "Expired", set the color to red.
  • If Status is "Not Expired", set the color to green.
  • hawkeye159's avatar
    hawkeye159
    Frequent Visitor
    2 years ago

    Thank you so much, that works for me!