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 ;
![]()
Table.TransformColumns( Source, {"Date", each Number.From( Text.From(Date.Year(_)) & Text.PadStart( Text.From( Date.Month(_)),2,"0")) } )
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.
Bookmarks