Forum Discussion
Helper IVDatetime column is in AM/PM format after export to Excel
My suggestion is not to use "General Date". I would scroll down the list and pick a specific format.
The other element to consider here is the date/time format of the column or measure itself. Find the column/measure within Power BI Desktop and check what formatting is being applied in the model itself. This is different to the localisation you have mentioned. This formatting will be what the date/time looks like. For example, do you want month as a word or 2 numbers. How many numbers for year. Do you want AM/PM etc. In other places this is known as the format string.
The localisation you mentioned gets applied later. Certain format strings will change with localisation. For example AM/PM might show diffferently in another language. A format like DD/MM/YYYY might change to MM/DD/YYYY in America.
- Jan_Trummel
Hello Anonymous ,
thanks for your answer!
In Power BI Desktop, the column also has a date/time format without AM/PM. The data type is also
date/time. So that can't be the problem.
The column in Power BI Desktop
Do you have any other idea why the Excel file is in AM/PM format?
My suggestion is not to use "General Date". I would scroll down the list and pick a specific format.
- Jan_Trummel
Thank you Anonymous ,
that was helpful!
