EOMONTH Not Working Date/Time fields

[NishanthReddy]

Hi Everyone,

With below formula, I've created a column which shows True for all the dates of current quarter.
Current Qtr =
VAR _StartOfQtr = DATE ( YEAR ( TODAY()), FLOOR ( MONTH ( TODAY() ) -1 , 3 ) + 1 , 1 )
VAR _EndOfQtr =CALCULATE( EOMONTH ( _StartOfQtr, 2 ))
RETURN
'Table'[Date] >= _StartOfQtr && 'Table'[Date] <= _EndOfQt

But, I dont for some reason. It is not working for the date/time fields. It is not considering Dec 31st 2023 1:00:00AM belong to current quarter. Not only with december last day of every quarter if the date field having time greater tha 1:00:00AM .

Can anyone help me how to solve this?

Thanks in advance.

[v-xiaosun-msft]

Hi @NishanthReddy ,

According to your description, I suggest that you can check the "DATE" table you created. In your screenshot, it shows detailed time periods. And when using the general date table, your formula works fine.

Please refer to the following link about date with different time periods.

Power BI Time Data Processing Summary - Brief Book (jianshu.com)

Best Regards,
Community Support Team _ xiaosun

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.