Forum Discussion

Wedding55's avatar
Wedding55
Helper 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)

     

Wedding55's avatar
Wedding55
Helper II
5 years ago

Hi MFelix v-zhenbw-msft 

 

Please excuse the delayed answer. I wasn`t in the office.

Its not the exaxt thing im searching for. I uploaded the test file on dropbox. See Link. I hope it works.

 

https://www.dropbox.com/s/jd6gpquzgppqy89/Test.pbix?dl=0

 

You can see there is Data until december 2020. But normally i update the file after each month. In this case the data until october is fix and the data for november and december is the forecast. Next month (in december) i update the file with the fixed november data and the data for december and january is the forecast. And the forecat i need the mark in different colors.

 

Is this possible? Thanks in advance 🙂

 

Best Regards

MFelix's avatar
MFelix
Super User
5 years ago

Hi Wedding55 ,

 

The solution I provide check if the date is higher than today and if yes returns 1 otherwise 0 then you can use this to make the condittional formatting.

 

Only question here is if you want to compare with todays date or with the updated date of the file but the principle is the same.

 

 

How do you determine if that particular month is actual or not by the updated date or today's date?