Power Query - Previous Row Hack

[@kebincui]

Excellent as always. Thank you James for all the videos you did in 2023 and wish you all the best in 2024 and look forward to more videos in the new year. 👍❤🌹

[@basensei8699]

thanks man! and all the best for you also!

[@kebincui]

@@basensei8699 I enjoy watching your video. For this one, the last step can be made shorter by using ?? operator: = Table.AddColumn(#"Changed Type1", "NrOfDays", each Duration.Days(([EndDate]??DateTime.Date(DateTime.FixedLocalNow())) - [StartDate]))

[@mnowako]

Another great video! Many thanks!

[@mirrrvelll5164]

This was a neat one =) good job!

[@basensei8699]

Thank you! 😄

[@txreal2]

Thanks. Happy New Year 🗽2024
Looking forward to your 2024 videos

[@basensei8699]

Happy new year!

[@raimundojs9547]

Great!!!