EOMONTH not working as expected

[Anonymous]

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 two meetings that fall on the 31st and if i use >= with eomonth they appear.

CALCULATETABLE('Meeting (3)', 'Meeting (3)'[Start Time] >= TODAY() && 'Meeting (3)'[Start Time] <= EOMONTH(TODAY(),0))

Any help would be appreciated

[amitchandak]

You are using start_time. Does it have time?  If yes better to try

<(EOMONTH(TODAY(),0)+1)

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges

Connect on Linkedin

[Anonymous]

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

[amitchandak]

In date, you can add days without using dateadd.

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

[Anonymous]

Awesome, thanks a lot amitchandak

[amitchandak · Accepted solution]

Like

CALCULATETABLE('Meeting (3)', 'Meeting (3)'[Start Time] >= TODAY() && 'Meeting (3)'[Start Time] < (EOMONTH(TODAY(),0)+1))