Power query Date Column Starting today

I've had a go a creating a date column starting 'today' for a given number of days,
and have done so, but I'm not sure if it's the best way essentially

Please Login or Register  to view this content.

Can anyone suggest better ways of doing this?

I've attached the file.

Richard

Administrative Note:

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

I told you how to do it:

Please take a moment to add the tags. Posting code between [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

I did not mention using < or > at all.

I have done it for you (corrected your attempt).

Juat click EDIT to see the post in the edit window and you will then be able to see the [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags I added. That's all you need to do.

Easiest way: select the code and click the # button on the edit toolbar.

Personally, I'd not add the column to the table. But keep it separate and use Index column to relate the two.
But other than that, only recommendation is to use

Formula:

Please Login or Register  to view this content.

instead of

Formula:

Please Login or Register  to view this content.

This isn't critical in most cases, especially when calculation is done once. However, since you are iterating over each row. It is best to use Fixed, so that it does not change value within context of the expression.

Ex:

Please Login or Register  to view this content.