Calendar measure issue - Forecast show the next month over the up coming years.

[Anonymous]

Dear everyone,

I have an issue regarding a calendar column that I created. 

In fact, I would like a formula which include the full current month with the future month coming on this year and over the next years. Actually, this is a kind of forecast. 

My current formula on the calendar is the following :

Flag After Today = if('Calendar'[Date] >= TODAY();"Yes";"No")

As you can guess, the issue is that it does not include the current month starting from 01/11. 

How can I do to show the full current month with the next month coming over 2019,2020 etc.

Thanks you very much.

Regards,

[Ashish_Mathur]

Hi,

Does this work?

Flag After Today = if('Calendar'[Date] >= EOMONTH(TODAY(),-1)+1;"Yes";"No")

[v-juanli-msft · Accepted solution]

Hi @Anonymous 

Create a measure

Measure = IF(DATEDIFF(TODAY(),MAX('calendar'[Date]),MONTH)>=0,1,0)

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

I tried this measure : 

Flag After today = if(AND(month('Calendar'[Date])>=month(today());year('Calendar'[Date])>=year(now()));"Yes";"No")

But it shows the full month November, which is a good point and the month of december. But when I go on 2020, the filter is also for November and December. 😕 I want the full current month with the future last month of 2019 and the months of 2020; 2021 etc.