Fix the Date function in DAX

[karljackson]

Below is an issue a fair few people are facing.
I'm not sure it's been raised so i'm raising / re-raising.

All be-it there's cira 16 replies, maybe more people are facing this issue?

Many of us are refusing to update from Feb Desktop version being scared that reports will fail.

Is there any chance this could be reviewed?

https://theleadagency.atlassian.net/jira/software/c/projects/BI/boards/242?assignee=61eac1b2fd5a6900...

[msgracegong]

Hi Karli, thanks for raising this issue. Im a PM on the Power BI team supporting desktop and our team is in discussions internally to see if we can expand our support for the ARM scenario. If you have any more comments or details you would like to provide, feel free to add that in the support ticket or in this forum and our team will review. Best regards, Grace

[Versus]

Are there any news on this fix? Date fields on ARM processors are causing error ``` An unexpected error occurred (file", line, function "). ``` It happens in DAX or even if a visual has a filter by date (for example "Last 30 days"). While it allegedly works in Feb'25 version, May'25 version does not work and I can't downgrade the May'25 PBIX files to Feb'25. So, I am stuck here. I would appreciate a solution

[Versus]

I give an example. This works fine: 

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

but this doesn't:

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

The field is of type `date`.

[Stinkys]

Don't forget to pop over to this thread and upvote - https://community.fabric.microsoft.com/t5/Fabric-Ideas/Make-power-BI-desktop-fully-compatible-with-A...

[JoaPalmer]

Please looking for help on this. I have Power Bi reports failing with the wierd error even if there is not even any DAX syntax with date involved. Just that I have objects and pages using a filter on date values. If I remove the date filter the report works again. This is terrible, all our reports are broken and no one seem to be able to help... 😞

[Stinkys]

@JoaPalmer downgrade power bi to feb version should get you up and running. Look at my profile post history for details.