Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
ajin
Helper II
Helper II

Date Format help

Hi Guys, 

 

Need some help with the below scenario, 

 

I have a date column with a format dd-mmm-yy. I needed to change this to dd-mmm-yyyy without adding a new column. Hence i made the date column as measure by using sum. SInce the measure had a total, to hide the total i used another measure. (Display Measure = if(HASONEVALUE(XXPBI_SHIPMENT_MV[Confirm Date]),XXPBI_SHIPMENT_MV[Measure],BLANK())  ). Now to change the format i used another measure with the format function  - format([display measure], "DD-MMM-YYYY). This was not showing all values. Further the year was a sum in some rows. But it was displaying correctly in one page and in another it wasn't. Attached the snippets. date format snippet.PNGdate format snippet with sum.PNG

2 REPLIES 2
v-shex-msft
Community Support
Community Support

HI @ajin,

 

It is hard to troubleshooting from your snapshot, can you please share a pbix file with some sample data for test?

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Hi Sheng,

 

This there are some confidentalitly issues, i cant share the sample. 

 

Thanks 

Aj

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors