Forum Discussion

ScholesBI's avatar
ScholesBI
Frequent Visitor
5 years ago
Solved

Next N Months date table

Hi,   I want to add a classification to my date table I have already added:     IsCurrentQuarter = var qtr = QUARTER('Calendar'[Date]) var curr_qtr =QUARTER(TODAY()) var yr = YEAR('Calendar'[...
Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    5 years ago

    That would just be 

    IsupcomingNmonths = 
VAR _Months = DATEDIFF ( TODAY(), 'Calendar'[Date], MONTH )
RETURN 
IF ( _Months >= 0 && _Months <= 2, "Yes", "No" )
jdbuchanan71's avatar
jdbuchanan71
Super User
5 years ago

That would just be 

IsupcomingNmonths = 
VAR _Months = DATEDIFF ( TODAY(), 'Calendar'[Date], MONTH )
RETURN 
IF ( _Months >= 0 && _Months <= 2, "Yes", "No" )