I have a date column in my table and then another column to extract the name of the month of the date column.
Example:
Date Month_Name
01/21/2021 January
03/05/2021 March
08/04/2021 August
I used the following script:
"Extracted Month Name" = Table.TransformColumns(#"Filtered Rows", { {"Month_Name", each Date.MonthName(_), type text}})
When I populate my Power BI dashboard and bring in the Month_Name column, it is not ordering by date, it's ordering alphabetically.
(August, January, March)
How can I use ORDER BY in VS? I cannot edit in PBI since I'm using SQL Server in VS.