Calculation of number of wworking days between dates for a specific month

[maart666]

Hello,

I need to calculate the number of working days between two dates. Everything is fine if the start and end dates are in the same month. But if the period is at the turn of the month, the values are incorrect (the number of days is counted to the month with the starting date). Here are simple example of PBI file:
https://www.dropbox.com/s/r7e8twi9720vz6d/List.pbix?dl=0

 

Thank you for any tips.

Marcin 

[daxer-almighty]

You have to wrap DATESBETWEEN in KEEPFILTERS. Also, if you're planning on slicing by 'Working Day' in the UI, you have to wrap it in KEEPFILTERS.

[maart666]

Thank you, i was managed to calculate it.

Marcin