Power Query Date Formate

[ahmedismailfourtex]

Hello.
i have months column contain the months in ( Jan - Feb - etic .. ) and the power query read it as a text when i change it date it give error
How to keep it ( Jan - Feb - etic .. ) with date format so i can use it in pivot tables and so.
Best regards

 

[billszysz]

One of ways:

let
    HelperTbl  = Table.Buffer(Table.FromColumns({{"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"},{1..12}}, {"MonthName", "Number"})),
    Source = Excel.CurrentWorkbook(){[Name="Tabela1"]}[Content],
    MonthNumber = Table.TransformColumns(Source,{{"Months",  (x) =>Table.SelectRows(HelperTbl, each [MonthName]=x)[Number]{0}}})
in
    MonthNumber

Regards

PS Here is an example file.
https://drive.google.com/file/d/0B6UlMk8OzUrxR0hVak5nMW1ONlU/view?usp=sharing

 

[one3nine0]

If you have the month numbers in a separate column as well, you can use the sort by function to sort the month names by the month number. That way when you use months in a pivot table or chart it will sort by the month order correctly.

 

[ahmedismailfourtex]

Thanks
Do u Have Video about it and other tricks ?

 

[ahmedismailfourtex]

thank u dear its easy way