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. Last Day of Last Month 

 

Please help me with this 

 

Thanks in Advance

Anil

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

1 Reply

  • 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