Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

karljackson

Fix the Date function in DAX

Submitted by Advocate I on ‎05-28-2025 07:11 AM

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...

Status: New
See more ideas labeled with:
6 Comments (6 New)
Comments
msgracegong
Microsoft Employee
Microsoft Employee
‎06-06-2025 12:54 PM
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
New Member
‎06-12-2025 12:09 AM
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
New Member
‎06-12-2025 12:14 AM

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
Advocate II
Advocate II
‎06-12-2025 02:47 PM
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
Frequent Visitor
‎06-18-2025 03:19 AM
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
Advocate II
Advocate II
‎06-18-2025 04:05 AM
@JoaPalmer downgrade power bi to feb version should get you up and running. Look at my profile post history for details.
Idea Statuses