cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Anonymous
Not applicable

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

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,

1 ACCEPTED SOLUTION
Community Support

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.

3 REPLIES 3
Super User

Hi,

Does this work?

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

Regards,
Ashish Mathur
http://www.ashishmathur.com
Community Support

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
Not applicable

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.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

#### Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

#### Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors