Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Help with Dates

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. La...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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