Order By in VS to represent in Power BI

[Anonymous]

I am using a SQL Server connection in VS and importing tables. In my table, I have a Date column and then another column that is extracting the Month_Name of the Date column. 

Example
Date                      Month_Name

01/05/2021            January

03/07/2021            March

08/21/2021            August

I used the following script in Advanced Editor in VS to do this:

#"Extracted Month Name" = Table.TransformColumns(#"Filtered Rows", {{"Month_Name", each Date.MonthName(_), type text}})

Then when I go to by Power BI dashboard and display the Month_Name in a table, it is not ordering by date, it's ordering alphabetically. 

(August, January, March)

How do I get this column to order by date?

(Can't edit the column in PBI since I'm using a VS connector)

[Greg_Deckler]

@Anonymous Hmm, well, you need to use a Sort By column that is the numeric month number.