Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
In DAX Studio:
When I run: EVALUATE row("A",EOMONTH (min(Sales[OrderDate]),3))
I correctly get:
A |
10/31/2001 12:00:00 AM |
When I run: EVALUATE row("B",ENDOFMONTH (Sales[OrderDate])+1)
I incorrectly get:
B |
8/1/2004 12:00:00 AM |
I expected 8/1/2001
However, When I run:
EVALUATE
FILTER( ALL ( Calendar ),
'Calendar'[Date] >= ENDOFMONTH (Sales[OrderDate])+1
&&
'Calendar'[Date] <= EOMONTH (min(Sales[OrderDate]),3)
)
I unfortunately get:
Date |
8/16/2001 12:00:00 AM |
9/11/2001 12:00:00 AM |
10/24/2001 12:00:00 AM |
Can you explain? I expect a resultant date range from B to A.
Solved! Go to Solution.
Solved. Dropped the endofmonth and converted to eomonth for both filters.
Solved. Dropped the endofmonth and converted to eomonth for both filters.
Hi @cnestg8r,
Congratulations, you have resolved your issue by yourself. Please mark the workaround as answer, so more people will benefit from it.
Best Regards,
Angelia
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
98 | |
75 | |
63 | |
62 |
User | Count |
---|---|
135 | |
105 | |
104 | |
80 | |
65 |