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,
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!