Forum Discussion

PDeGaris's avatar
PDeGaris
New Member
2 years ago
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...
Need Help
  • PDeGaris's avatar
    PDeGaris
    2 years ago

    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.

HotChilli's avatar
HotChilli
Community Champion
2 years ago

There's not enough detail in the question to help you.  Can you provide the pbix please?

PDeGaris's avatar
PDeGaris
New Member
2 years ago

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.