Hello everyone, I have done a lots of researches regarding the following requirement, but was not able to find a solution till yet.In one table I have the columns ID, year, value and lots of other columns. It's looking like the following example. ID | year | value | n columns123 | 2020 | 1200 | xyz132 | 2020 | 2400 | xyz result should byID | date | value | n columns123 | 01.01.2020 | 100 | xyz123 | 01.02.2002 | 100 | xyz...132 | 01.01.2020 | 200 | xyz132 | 01.02.2020 | 200 | xyz Does anybody have a hint for me how to solve this with M? Thank you guys 😉

Hello Anonymous this is a little different approach with List.Generate and calculates the first day of every month. I think the approach of edhans is working as well, only that the number should be used for month instead of days. let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjQyVtJRMjIwMgBShkYGBkqxOkBRYyOEqJEJSDQWAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [ID = _t, Year = _t, Value = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"ID", Int64.Type}, {"Year", Int64.Type}, {"Value", Int64.Type}}), #"Added Custom" = Table.AddColumn(#"Changed Type", "Months", (listcustom)=> List.Generate(()=> #date(listcustom[Year],1,1),each _ < #date(listcustom[Year]+1,1,1),each Date.AddMonths(_,1))), #"Expanded Custom" = Table.ExpandListColumn(#"Added Custom", "Months"), #"Added Custom1" = Table.AddColumn(#"Expanded Custom", "MonthValue", each [Value]/12) in #"Added Custom1" Copy paste this code to the advanced editor in a new blank query to see how the solution works.If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)Kudoes are nice tooHave funJimmy

Transform row with year and value to multiple rows for months and value/12

Forum Discussion

Related content

Transform columns / type

Table Transformation

Data transform using power query

Table Transformation

M Language Transformations