There is no NETWORKDAYS function in PQ. You can follow a process such as the one outlined in this article gorilla.bi/power-query/working-days-between-dates/
How can I can do that in networkdays (without Saturday and Sunday and holiday days) : Column Discunted days New Column Result 24/06/2024 -3 dias = 19/06/2024
Clear explanation, no fiss-fuss, a big thanks for the video
Nice video 📹 👍 Thank you for sharing your knowledge with us
Thank you Nader 🙂
Perfect, nice to know! Thanks
Happy to help! Thank you, Anders.
Thank you, great tutorial!
My pleasure.
Thanks for video, however when i do the -1, my result just comes up as -1 for all the rows.. What am i doing wrong.?
Hello can we done the same calculation in power query please?
There is no NETWORKDAYS function in PQ. You can follow a process such as the one outlined in this article gorilla.bi/power-query/working-days-between-dates/
👍👍👍👍👍
How can I can do that in networkdays (without Saturday and Sunday and holiday days) :
Column Discunted days New Column Result
24/06/2024 -3 dias = 19/06/2024