start month as april

[_Janwi31]

In the power query , i have put my start as april but when i am applying it, it is starting as july.

I want to start the date from april.

Please guide me through this.

[v-yanjiang-msft]

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

[_Janwi31]

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?

[v-yanjiang-msft]

Hi @_Janwi31 ,

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

Best regards,

Community Support Team_yanjiang

[_Janwi31]

yeah it worked.

Thanks @v-yanjiang-msft 

[v-yanjiang-msft]

Hi @_Janwi31 ,

It's my pleasure!

Best regards,

Community Support Team_yanjiang