Index column in calculated table

Hello Anonymous ,

You can create sort column in power query editor. by extracting month and year in two separate column and then create custom column two combine that yearmonth like 20181 and then use that column to sort.

Then you will not have circular depedency issue in report.

#"Inserted Month" = Table.AddColumn(#"Changed Type", "Month", each Date.Month([Date_Added]), Int64.Type),
#"Inserted Year" = Table.AddColumn(#"Inserted Month", "Year", each Date.Year([Date_Added]), Int64.Type),
#"Changed Type1" = Table.TransformColumnTypes(#"Inserted Year",{{"Month", type text}, {"Year", type text}}),
#"Added Custom" = Table.AddColumn(#"Changed Type1", "Custom", each [Year]&""&[Month])