Forum Discussion
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...
Like
CALCULATETABLE('Meeting (3)', 'Meeting (3)'[Start Time] >= TODAY() && 'Meeting (3)'[Start Time] < (EOMONTH(TODAY(),0)+1))
amitchandak
Super User
Super UserYou 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
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
- amitchandak
Like
CALCULATETABLE('Meeting (3)', 'Meeting (3)'[Start Time] >= TODAY() && 'Meeting (3)'[Start Time] < (EOMONTH(TODAY(),0)+1)) 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'
Awesome, thanks a lot amitchandak