Forum Discussion
Solved
Date format issues
Hi, I have a date formatting issue - BI is recognising a date (Dec-2022) as both Dec-2022 and Dec- 2023? P & L matrix is showing Dec-2022 in a filtered visual for both FY 2022 and FY 2023. AC valu...
Thanks HotChilli,
I seem to have solved the issue just now - the date our financial software exports as the month is the 12/23/22 (mm/dd/yy) (seems the 23rd is an odd day to pick but that's another issue) - for some reason any spreadsheets with a 2022 year date, BI was reading the year as 23. Changing the date format in the original excel files to dd/mm/yyyy fixed the problem.
Thanks Anyway.
There's not enough detail in the question to help you. Can you provide the pbix please?