How to express Next Month First Day, Prev. Month First Day etc. (Time intelligence question)

[JustinDoh1]

Hi Community,

I am trying to write DAX on following examples (as shown below):

Based on value of "Date" (like 02/20/2021, 01/10/2021), I would like to create column value like "Next Month First Day", "Current Month First Day", "2 Month..", "4 Month.." etc.

I think creating Column is what I needed now, but if there is a way to create Measure, I will use later.

Thanks.

[Whitewater100]

Hi Justin:

Anoter variation you might like is:

=NEXTDAY(LASTDATE(Dates[Date]))

It's less code and works if you are set up by month. Just FYI. Bill

[Whitewater100 · Accepted solution]

Hi:

If your matrix has month as column, then this would work as a measure:

Next Month First Day =

VAR dayone = CALCULATE(Max(Dates[Date]))

return

CALCULATE(dayone, DATEADD(Dates[Date],1,MONTH))+1

[JustinDoh1]

@Whitewater100 

Thank you so much! How do we express in Column by chance?

[Whitewater100]

Hi:

NP. 

Begin Next Month =

VAR currdate = Dates[Date]

return

EOMONTH(currdate,0)+1

If it works well, please accept as solution. Thanks!

[JustinDoh1]

I got this now in column:
Current Month First Day1 = EOMONTH(CALENDAR[Date] ,-1)+1

2 Month Ago First Day1 = EOMONTH(CALENDAR[Date] ,-3)+1