Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
64
Views
Topic starter
A great example is given in this exercise of subtracting one date from another. This is a process I use regularly. However, I generally like to use =NETWORKDAYS. What is the process used in Power Query to undertake this calculation? I am called on to provide accurate DIFOT reports each month, and this will form part of our Power Bi Dashboard.
Thanks, Steve L
Posted : 15/12/2020 12:37 am
Hi Steve,
That function does not exist in PQ, you have to recreate it.
There is an example here:
https://www.thebiccountant.com/2020/02/20/date-networkdays-function-for-power-query-and-power-bi/
Posted : 15/12/2020 2:01 am
