Operation with Inicial dates and Final dates from month to month

[barbaracruvinel]

I have this part of the code in the power query that makes for each day between the start and end date.

 #"Added Custom" = Table.AddColumn(#"Calculated Start of Month1", "Mensal Date", each {Number.From([#"Initial Date - Copy"])..Number.From([#"Final Date - Copy"])}),

I need it to be the month-to-month date.

Exemplo:

it is like this

1/1/2018

1/2/2018

1/3/2018

1/4/2018

1/5/2018

1/6/2018

1/7/2018

1/8/2018

1/9/2018

1/10/2018

1/11/2018

1/12/2018

1/13/2018

1/14/2018

1/15/2018

1/16/2018

and I need dates like this:

I need it like this

1/1/2018

2/1/2018

3/1/2018

4/1/2018

5/1/2018

6/1/2018

7/1/2018

8/1/2018

9/1/2018

10/1/2018

11/1/2018

12/1/2018

1/1/2019

2/1/2019

3/1/2019

4/1/2019

from month to month.

[chrisbind · Accepted solution]

In PQ Editor, right-click the date column and select Transform > Month > Start of Month. Follow up by removing duplicates (or Group by, if you have measures that need aggregation).