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...
  • 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.
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.