Forum Discussion
Issue in conversion of csv dates in PowerBI
Hi all, I'm attempting to create a line graph using the data from excel saved in CSV format. The issue is that because of the conversion the PBI is reading the data as Jan 1, Jan 2 instead of Jan...
v-jingzhang thanks for your response. I havent tried your solution but what worked was using the text to column feature and recreating a custom column for the date function.
I have created the calendar table using the CalendarAuto function in Power Query. Here you go!