Thanks for the insights ... can we also have access to the file with the PowerQuery code as produced during the session? Thx If not I have it available if anyone wants. @Enrico in chat: yes you can create a new column with Date.MonthName() like this: = Table.AddColumn(#"Changed Type1", "Month Name", each Date.MonthName([Month], "en-BE"), type text) To have it properly sorted you have to sort the field in the PivotTable by sorting with 'More option' on the Month name, and selection the appropriate Custom Filter List in the dropdown...
Another solution instead of List.Generate that can simply be used as a Custom Column: = Table.AddColumn(#"Replaced Value", "Custom", each List.Distinct(List.Transform({Number.From([Start date])..Number.From([End date])}, each Date.StartOfMonth(Date.From(_)))))
Join London Excel Meetup Events
www.meetup.com/london-excel-meetup-group/
Wonderful Class, Thank you CGG!!!
You' re very welcome. Malina is great.
Really good example. Thank you.
Glad you enjoyed it!
Hi Hello the pivot table from the 1 example in not in the order of Months, mine is 1, 10, 11 , 12 , 2....9.
Sounds like the month number is stored as text rather than numeric. I would look at changing the data type in PQ.
@@Computergaga yes tks a lot
Hello super heroes ❤
hello, hello
Hello Boss, How Are You. Hopes! Doing Well😁
@@xeeshanahmad8757 absolutely. Very well, thank you.
Thanks for the insights ... can we also have access to the file with the PowerQuery code as produced during the session? Thx
If not I have it available if anyone wants.
@Enrico in chat: yes you can create a new column with Date.MonthName() like this:
= Table.AddColumn(#"Changed Type1", "Month Name", each Date.MonthName([Month], "en-BE"), type text)
To have it properly sorted you have to sort the field in the PivotTable by sorting with 'More option' on the Month name, and selection the appropriate Custom Filter List in the dropdown...
Thank you, Danny. I'll check on the files and get them uploaded if Malina provides.
Another solution instead of List.Generate that can simply be used as a Custom Column:
= Table.AddColumn(#"Replaced Value", "Custom", each List.Distinct(List.Transform({Number.From([Start date])..Number.From([End date])}, each Date.StartOfMonth(Date.From(_)))))