Showing current month and future months

[abeirne]

Hi all, I am trying to figure out the proper dax for filtering my date table to show the current month and future months. I am working on a PACE/lead time report. I have this column in my calendar table:

IF(
      CalendarQ[Year] >= YEAR(TODAY()) && CalendarQ[Month] >= MONTH(TODAY()),
      1,
      0
)
But this only shows today to EOY and next year after the current month. I wanna see the current month and forward months.

I can do 
IF(
      CalendarQ[Date] >= TODAY(),
      1,
      0
)
But that only shows current day + and I would like to see current month + .

Thank you for your help.

[daXtreme · Accepted solution]

[Your Column] = 
var CurrentYear = YEAR( TODAY() )
var CurrentMonth = MONTH( TODAY() )
var CurrentMonthId = CurrentYear * 100 + CurrentMonth
var Output = INT( 'Calendar'[MonthId] >= CurrentMonthId )
return
    Output

Create a column in your Calendar that's MonthId = year( [date] ) * 100 + month( [date] ). You'll then use this in the formula above.

[abeirne]

Awesome thank you!