Calculated column to get the first date of next month?

[Anonymous]

I have a column with dates of the format: 4/25/21. I want a new column that will calculate the first date of next month, no matter what day it is this month

I tried this code:

Future Effective Date = EOMONTH('Account Move Audit Log - Dashboard'[Effective Date],1)+1

It seems to only give me the end of next month, however. I'm lost on this one... 

[Jihwan_Kim]

Hi, @Anonymous 

I am not sure about your table name and column name.

Please try something like below to make a calculated column.

nextmonthfirstdate = EOMONTH('Calendar'[Date],0)+1

Jihwan Kim

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

[Anonymous]

@Jihwan_Kim This works great, but I have noticed an issue in my logic. It will apply to any date, even past dates.

Is there any way to apply a filter on top of this EOMONTH to also filter any date out that is in the past? So for example, if date >=today, then EOMONTH('Calendar'[Date],0)+1?

i.e. 

Future Dates = IF('Account Move Audit Log - Dashboard'[Effective Date]<=TODAY() THEN EOMONTH('Account Move Audit Log - Dashboard'[Effective Date],0)+1 ?

[Jihwan_Kim · Accepted solution]

Hi, @Anonymous 

Thank you for your feedback.

Yes, you can create that.

nextmonthfirstdate = IF( 'Calendar'[Date] >= TODAY(), EOMONTH('Calendar'[Date],0)+1)

Jihwan Kim

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