Forum Discussion
Power query help
Example table
Calculated column
Expand to new rows
Expanded tableNew calculated columnResult
https://docs.microsoft.com/en-us/powerquery-m/list-dates
Create a new column with your month column as count and month as duration. Then expand into new rows.
tex628 thank you so much for the response so would it look like this
List.Dates([DateInvoiced],[Months], [Months] )
thank you
Nevermind that, apparently its not that simple.
It appear that list.dates cant use month as increment which leaves us with a more complicated solution.
Use List.Numbers to create a record for each month. So you would do something along the lines of:List.Numbers( 0 , [Month] )
https://docs.microsoft.com/en-us/powerquery-m/list-numbers
When the list is expanded you should end up with 1 record representing each month. 1, 2, 3, 4, 5 etc.
Now you want to create a new column using:Date.AddMonths( [DateInvoiced] , [New column that you just made] )
https://docs.microsoft.com/en-us/powerquery-m/date-addmonths
This should give you the desired result! Sorry for the missdirect in the beginning, hope it works out.
Br,
Jtex628 but wont that just give me the end date i need all the iterim dates in between as a list. Thank you for all your help