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: 

Get Fabric certified for FREE! Don't miss your chance! Learn more

Reply
fksng66
Helper II
Helper II

Date format issue

‎06-04-2025 01:37 AM

Hi there, I'am trying to get the last date value of each month, for example I should only be getting sum of all values on 31st May 2025, but the final value output doesn't seem to match with the expected result. I noticed that on my table the date format on the date column is mm/dd/yyyy for date 1-12, but it switched to dd/mm/yyyy starting 13-31

 

Is there anywhere I can change the date format to be the same? I wonder if it's why I couldn't get the correct expected result.

 

fksng66_0-1749025683209.png

 

Labels:
Message 1 of 22
2,920 Views
0
1 ACCEPTED SOLUTION
v-hashadapu
Community Support
Community Support
In response to fksng66

‎07-14-2025 05:04 AM

Hi @fksng66 , Thank you for reaching out to the Microsoft Community Forum.

 

Unfortunately, what you're trying to do isn't possible with DAX or measures alone while the date column has inconsistent formats like mm/dd/yyyy and dd/mm/yyyy. Power BI cannot reliably detect the correct last date of the month if it's misinterpreting some dates (like 05/12/2025 being seen as December 5 instead of May 12).

 

The only way to make your original formula work is to ensure the column is a proper Date type with a consistent format during the data load stage ideally in Power Query using the Change Type Using Locale option. Otherwise, any logic based on date comparisons will return incorrect results.

 

I know it's not the answer you'd hoped for but just wanted to clarify that this limitation isn't something DAX or visuals can fix it has to be resolved at the source or Power Query level.

 

Custom Date Formats in Power BI Using a Slicer - Microsoft Fabric Community

View solution in original post

Message 21 of 22
2,030 Views
21 REPLIES 21
fksng66
Helper II
Helper II
In response to burakkaragoz

‎06-04-2025 07:33 PM

Hi thanks for the reply, I've tried to change it on both power query and also source file but doesn't seems to make all into the same dd/mm/yyyy format still

 

fksng66_0-1749090782811.png

 

Message 3 of 22
1,110 Views
0

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

February Power BI Update Carousel

Power BI Monthly Update - February 2026

Check out the February 2026 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All