Power Query - Previous Row Hack
ฝัง
- เผยแพร่เมื่อ 29 ธ.ค. 2023
- There are many ways to refer to the previous row in dataset in power query. in this tutorial i demonstrate a specific use case where you can kind of previous row hack using lists.
#dataanalytics #powerbi #powerbidesktop #powerquery #excel
File Link
github.com/jbotes/powerbiTuto...
Another great video! Many thanks!
Great!!!
This was a neat one =) good job!
Thank you! 😄
Thanks. Happy New Year 🗽2024
Looking forward to your 2024 videos
Happy new year!
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. 👍❤🌹
thanks man! and all the best for you also!
@@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]))