Forum Discussion

Wedding55's avatar
Wedding55
Icon for Helper II rankHelper II
5 years ago
Solved

Different Colors Datesbetween Measure

Hello,   i have four measures to calculate the different financial years. The measures are the same, only the time horizon is different.   Days 20/21 = CALCULATE(SUM('Process Data'[Tage]), DATES...
Need Help
  • MFelix's avatar
    MFelix
    5 years ago

    Hi Wedding55 ,

     

    My mistake since you are using months (that aggregate more than one date) you need to use the MAX instead of a selectedvalue:

     

    Condittional Formatting = IF(MAX(Tabelle[Date]) >= TODAY();1;0)

     

MFelix's avatar
MFelix
Icon for Super User rankSuper User
5 years ago

Hi Wedding55 ,

 

My mistake since you are using months (that aggregate more than one date) you need to use the MAX instead of a selectedvalue:

 

Condittional Formatting = IF(MAX(Tabelle[Date]) >= TODAY();1;0)

 

Wedding55's avatar
Wedding55
Icon for Helper II rankHelper II
5 years ago

Thanks for your Help. Its working 🙂