Power Query Group by Year Month

[Dicken]

Hello,

Is there a way to group by Year Month combination and still keep as a number format so it will act as in index

I've transformed the date column to ;

Please Login or Register  to view this content.

Which does work, the only other way I can think is to transform each date to the start of the month but I would raelly like to keep
a MM - YYYY format , any ideas,


Richard.

[romperstomper]

Assuming it's a Date type, you could shorten that transformation to:

Please Login or Register  to view this content.

[Dicken]

Just to add I fount rick de groots article with all the text formats, so thanks, I had not known about this and would not have looked for it without your reply.