DAX Filtered Time Range

Question

In DAX Studio:When I run:&nbsp;&nbsp; EVALUATE row("A",EOMONTH (min(Sales[OrderDate]),3))I correctly get:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;A10/31/2001 12:00:00 AM&nbsp;When I run:&nbsp;&nbsp; EVALUATE row("B",ENDOFMONTH (Sales[OrderDate])+1)I incorrectly get:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;B8/1/2004 12:00:00 AMI expected 8/1/2001&nbsp;However, When I run:EVALUATE&nbsp;FILTER( ALL ( Calendar ),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'Calendar'[Date] &gt;= ENDOFMONTH (Sales[OrderDate])+1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&amp;&amp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'Calendar'[Date] &lt;= EOMONTH (min(Sales[OrderDate]),3)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;I unfortunately get:Date8/16/2001 12:00:00 AM9/11/2001 12:00:00 AM10/24/2001 12:00:00 AM&nbsp;Can you explain? I expect a resultant date range from B to A.

cnestg8r · Accepted Answer

Solved. Dropped the endofmonth and converted to eomonth for both filters.

Forum Discussion

DAX Filtered Time Range

2 Replies

Related content

Time Filter Slicer

Run a pipeline at time intervals within a specific time range

STATUS HISTORY RANGE TIME

Filter by time range- Hour

Time Relative filter