Compare Initial and Final Data

[Anonymous]

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 · Accepted solution]

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.