Doubt Multiple Rows

[vfernandes0408]

Hi,

i have a table when i have [Description],[StartDate], [EndDate] and [Value].

Description StartDate     EndDate      Value
Example      01/01/2018 01/12/2018 10

I need to final result with this information and stop on EndDate
Description Date            Value
Example 1   01/01/2018 10
Example 1   01/02/2018 10
Example 1   01/03/2018 10
Example 1   01/04/2018 10
Example 1   01/05/2018 10
Example 1   01/06/2018 10
Example 1   01/07/2018 10
Example 1   01/08/2018 10
Example 1   01/09/2018 10
Example 1   01/10/2018 10
Example 1   01/11/2018 10
Example 1   01/12/2018 10

[Stachu · Accepted solution]

in PowerQuery you can add custom column, with the following syntax

List.Dates([StartDate], Duration.Days([EndDate]-[StartDate]), #duration(1, 0, 0, 0))

end then expand the column to rows, and remove [StartDate] and [EndDate]

[vfernandes0408]

works fine, but when I post my question I put the wrong day and in its formula add days instead of month