Forum Discussion

Benedict21's avatar
Benedict21
Frequent Visitor
3 years ago
Solved

DAX next month

Hi,    I am trying to create a column in my Date table that indicates the next month of the current date. My column reads:   IsNextMonth2 = Month(Dates[Date]) = MONTH(NOW() + 1)   It is read...
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Benedict21 

    Try the code:

    Is Next_month = var to_date = EOMONTH(TODAY(),1)
    return YEAR('Month'[Date])=YEAR(to_date)&&MONTH('Month'[Date])=MONTH(to_date)

     

    Best Regards!

    Yolo Zhu

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Benedict21 

You can try the following code:

 

var to_date=EOMONTH(TODAY()),1)

return MONTH('Month'[Date])=MONTH(to_date)
 

Best Regards,

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Benedict21's avatar
Benedict21
Frequent Visitor
3 years ago

Hi, 

Thank you so much for your response. Again, only showing next month; not month and year. Any suggestions?

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Benedict21 

    Try the code:

    Is Next_month = var to_date = EOMONTH(TODAY(),1)
    return YEAR('Month'[Date])=YEAR(to_date)&&MONTH('Month'[Date])=MONTH(to_date)

     

    Best Regards!

    Yolo Zhu