Hi again,
Next problem: how to create a list of non-consecutive dates in Power Query.
Source data as follows:
<tbody>
</tbody>
Table (list) to be generated:
<tbody>
</tbody>
In other words, the earliest and latest dates needs to be identified from the source data, and then a list of dates 7 days apart should be generated (the dates are always a Monday).
Anyone have any ideas how this could be achieved?
Cheers,
Matty
Next problem: how to create a list of non-consecutive dates in Power Query.
Source data as follows:
Dates |
---|
11/12/2017 |
18/12/2017 |
25/12/2017 |
01/01/2018 |
08/01/2018 |
15/01/2018 |
22/01/2018 |
18/12/2017 |
25/12/2017 |
01/01/2018 |
08/01/2018 |
15/01/2018 |
22/01/2018 |
<tbody>
</tbody>
Table (list) to be generated:
Dates |
---|
11/12/2017 |
18/12/2017 |
25/12/2017 |
01/01/2018 |
08/01/2018 |
15/01/2018 |
22/01/2018 |
<tbody>
</tbody>
In other words, the earliest and latest dates needs to be identified from the source data, and then a list of dates 7 days apart should be generated (the dates are always a Monday).
Anyone have any ideas how this could be achieved?
Cheers,
Matty