Forum Discussion
cham
Post Patron
Post PatronDate format issue
Hi, I want to change the date format "Month/Date/Year" into "Date/Month/Year" format in Power BI. How can i do that. I have an excel sheet with date column it includes all the dates as "MM/DD...
chamPost Patron
Post PatronI export CSV file into Power BI. But some dates are showing as Error. Can I know the reason for that?
Also is this formula correct? Date = FORMAT(Sheet1[Date],"dd""mm""yyyy")
This is not working for me
v-juanli-msft
Community Support
Community SupportHi cham
This formula should be correct.
Date = FORMAT(Sheet1[Date],"dd/mm/yyyy")
It is a DAX formula used in a calculated column.
Is the column with error your original data or the modified data with any transformation?
Could you share me with data in your excel for analysis?
Best Regards
Maggie