dates

[MarcUrdang]

my date in Excel is dd/mm/yyyy

PBI reads in then as mm/dd/yyy so my data only pulls through January for example.

How do I get PBI to read it so that the date gets read as per Excel .. or do I need to ammend Excel to mm/dd/yyyy

any advice would be appreciated.

thanks

Marc

[v-lid-msft]

Hi @MarcUrdang ,

How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?

Best regards,

[v-lid-msft · Accepted solution]

Hi @MarcUrdang ,

We can add cultures parameter for example "gsw-FR" or "ar-BH" in the end of Table.TransformColumnTypes function to meet your requirement.

Best regards,

[amitchandak]

If the formatting solutions do not work out. Then mark that column as text and create a new date column.

Date formatted = mid(DD__MM__YY[Date],4,2) &"/"& left(DD__MM__YY[Date],2) & "/" & right(DD__MM__YY[Date],4)

Mark this new column as the date. Also, create one more column based on DD/MM/YYYY. Mark that also has text. use that column to display date in that format. Make the mm/dd/yyyy date column as sort column of the new column

[Tahreem24]

@MarcUrdang ,

Approach 1) Select your column --> go to modelling tab --> Data Type set to Date --> Format set to dd/mm/yyyy.

Approach 2) Create one calculated column like below:

Date = FORMAT('Table1'[DateColumn],"DD/MM/YYYY")

Please give Thumbs up for support and accept this as a solution if it helps you!

[YasirBilal]

Please See This Post

https://community.powerbi.com/t5/Desktop/How-to-change-the-date-format/td-p/40460