Forum Discussion
DAX next month
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
Hi Benedict21 ,
You can try the following code I modified:
IsNextMonth2 =
Month(Dates[Date]) = MONTH(MONTH(NOW())+1)
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.
Hi!
Thank you but this is only capturing the next month value, not the month and year value.
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.
Hi,
Thank you so much for your response. Again, only showing next month; not month and year. Any suggestions?
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