Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

EOMONTH not working as expected

Hi peeps   I'm using this formula to get some rows back but for some reason I cant get rows that fall on the 31/01/2020. Am I using eomonth incorrectly or is my dax query just incorrect. I have tw...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Like

    CALCULATETABLE('Meeting (3)', 'Meeting (3)'[Start Time] >= TODAY() && 'Meeting (3)'[Start Time] < (EOMONTH(TODAY(),0)+1))
Anonymous's avatar
Anonymous
Not applicable
6 years ago

This working as expected, just for my understanding what does the +1 represent?

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

In date, you can add days without using dateadd.

So instead of looking at <= '31-jan-2020' , we are saying <'01-feb-2020'

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Awesome, thanks a lot amitchandak