Forum Discussion
Solved
dates
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...
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,
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