start month as april

Hi _Janwi31 ,

What's the data source and the steps you are taking in Power Query to set the start date to April. Additionally, is "01 July 2023" the smallest day in your sample?

Best regards,

Community Support Team_yanjiang

Hi v-yanjiang-msft,

My data source is an excel file.

I am setting start date as "01-04-2023" and end date as "31-03-2024", then I make list of the dates and from them i make the whole calendar table.

When i come to power query editor all dates are right on their place. But when i apply, it starts as july in data view.

What can I do about it?

Hi _Janwi31 ,

I can't reproduce the problem, how about sort the column in data view.

Best regards,

Community Support Team_yanjiang

yeah it worked.

Thanks v-yanjiang-msft 

Hi _Janwi31 ,

It's my pleasure!

Best regards,

Community Support Team_yanjiang