Forum Discussion
Anonymous
1 year agoNot applicable
Date Filter Error
I have recently updated the Power Bi desktop: March 2025 Update (2.141.1228.0) But upon opening any file I get the following error: This has never happened before and causing issues updating ...
jkbrookes47
1 year agoNew Member
I was able to narrow this down further
FILTER(
ALL(BREAKDOWN_HISTORY),
BREAKDOWN_HISTORY[Period Date] >= DATE(2024, 4, 1) &&
BREAKDOWN_HISTORY[Period Date] <= DATE(2024, 12, 31)
)
but this works
FILTER(
ALL(BREAKDOWN_HISTORY),
BREAKDOWN_HISTORY[Period Date] <= DATE(2024, 12, 31) &&
BREAKDOWN_HISTORY[Period Date] >= DATE(2024, 4, 1)
)
The issue is that BREAKDOWN_HISTORY[Period Date] >= DATE(2024, 4, 1) but the workaround is to have it after BREAKDOWN_HISTORY[Period Date] <= DATE(2024, 12, 31)
This doesn't help if you are trying to use the between slicer (as I am) but I found if I apply the "before" slicer and then apply the "after" slicer that it will work, although ugly as hell.