Help with Dates

[Anonymous]

Hi All,

I'm very new to DAX and need help in below calculations with respect to based on Today's Date

1. First Day of Next Month 

2. 3rd Day of Next Month 

3. First Day of Last Month

4. Last Day of Last Month 

Please help me with this 

Thanks in Advance

Anil

[Anonymous · Accepted solution]

I got answers Guys

Figured it out somehow and everything is working as expected.

Posting the calculations to the forum so that I may help someone

First Day of Current Month = DATE(YEAR(TODAY()), MONTH(TODAY()), 1)
Last Day of Current Month = EOMONTH(today(),0)
First Day of Previous Month = EOMONTH(TODAY(),-2)+1
Last day of Previous Month = EOMONTH(TODAY(),-1)
First Day of Next Month = EOMONTH(TODAY(),0)+1
Last day of Previous Month = EOMONTH(TODAY(),-1)
Third Day of Next Month = EOMONTH(TODAY(),0)+3