Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Compare Initial and Final Data

I'm having trouble calculating, I need to present an indicator that if the end date is more than 14 days from the start date or is empty in the database it will turn red, if the end date was not more than 14 days from the start date, green

 

 

  • camargos88's avatar
    camargos88
    6 years ago

    Hi Anonymous ,

     

    Create this measure:

    Measure = IF(DATEDIFF(MAX('Table'[Data]), MAX('Table'[Data Final]), DAY)> 14, 1,0)
     
    And create a conditional formatting using this measure by rules.

1 Reply

  • camargos88's avatar
    camargos88
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Hi Anonymous ,

     

    Create this measure:

    Measure = IF(DATEDIFF(MAX('Table'[Data]), MAX('Table'[Data Final]), DAY)> 14, 1,0)
     
    And create a conditional formatting using this measure by rules.