Forum Discussion
Date 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...
Hi
Create a one variable and insert a date function and then convert the format(Date/Month/Year) according to your requirement in the Power BI.
Regards
Rohit
Do I need to add a column an put a "format" function in the report?
Hello Cham,
Yes.please put date fundtion and mention in which format you required.
Regards
Rohit
I 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
