Network Days Calculation between both Error shown

Anonymous

Not applicable

2 years ago

Your solutions is great bhanu_gautam

You can use the following DAX expression to calculate the number of network days excluding Saturday and Sunday:

NETWORKDAYS = NETWORKDAYS('Gobal_Master_Data_NA'[Received_Date],'Gobal_Master_Data_NA'[Completed_Date])

Here's the dataset I used:

Here are the results:

You can learn how to use this function from the link below:

I've uploaded the PBIX file I used this time below. In addition, I found a case with the same issue:

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion