Index column in calculated table
Hello, guys! Created dynamic date scales https://www.inkeysolutions.com/blogs/power-bi-dynamic-scales-values/ and got the problem. The x-axis sorted in a wrong way I created an "inde...
Forum Discussion
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])
its caclculated table. i cant use power querty editor unfortunelly.
