Forum Discussion

abeirne's avatar
abeirne
Icon for Helper II rankHelper II
4 years ago
Solved

Showing current month and future months

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.

Need Help
Need Help DAX
  • daXtreme's avatar
    daXtreme
    4 years ago
    [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.

2 Replies

  • daXtreme's avatar
    daXtreme
    Icon for Solution Sage rankSolution Sage
    4 years ago
    [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.