Add a "DayOffset" Column in Calendar Table using Power Query

[Anonymous]

Hello everyone, how can I add the column "DayOffset" to my Calendar Table using Power Query? I would appreciate it if you could give me an M code in order to add that column 🙂 If today is 06/19/2020 = 0, yesterday 06/18/2020 = -1, tomorrow 06/20/2020 = 1 then 2, 3, 4...etc

[lbendlin · Accepted solution]

Thank you for the challenge.

= Table.AddColumn(dbo_Dates, "dateindex", 
each Number.From([date]-Date.From(DateTime.LocalNow()))
)

[Anonymous]

Thanks a lot!

[lbendlin]

Just be careful with the timezone stuff, test in on the service before using it in production.