Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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 ...
General Comment
Need Help
Versus's avatar
Versus
New Member
1 year ago

The issue seems to be happening on ARM processors and relates to date fields. Even though they are data fields, they are processed as text, which is causing the issue (that's my assumption).

 

Date fields are not converted and this raises the error:

Companies2 (L28D) = 
CALCULATE(
    DISTINCTCOUNT(companies[id]),
    companies[created_at] >= TODAY() - 28 &&
    companies[created_at] < TODAY()
)

 

Here the dates are explicitly converted to dates and it works OK:

Companies (L28D) = 
CALCULATE(
    DISTINCTCOUNT(companies[id]),
    DATEVALUE(companies[created_at]) >= TODAY() - 28 &&
    DATEVALUE(companies[created_at]) < TODAY()
)

 

Unfortunately, there is no workaround for filters and visuals.  They display error anyway.