cancel
Showing results for
Did you mean:

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a \$100 discount. Register Now

Continued Contributor

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

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.

1 ACCEPTED SOLUTION
Solution Sage

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

5 REPLIES 5
Solution Sage

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

Solution Sage

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

Continued Contributor

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

Solution Sage

Hi:

NP.

Begin Next Month =
VAR currdate = Dates[Date]
return
EOMONTH(currdate,0)+1

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

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

Announcements

#### Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

#### Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

#### Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

#### Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors