Forum Discussion
Created an function and PowerBI gets slow
Hello,
I created a function in the transformation environment to extract the number of working day from two dates, this takes out holidays and weekends. When I implement the function in the transformation everything takes long. I have to wait for very long to see the previou of the data.
Any suggestions?. Thank You.
2 Replies
dcarreropi , you already have networkdays in dax
if that can help
Power BI - Business day with and without using DAX Function NETWORKDAYS: https://www.youtube.com/watch?v=Qs03ZZXXE_c
For power query , refer
somehow my powerbi doesn't have that networkdays function, any alternative solution besides the networkdays function?
