Summarising between 2 dates

Hi, McRobot 

Please check the below picture and the sample pbix file's link, whether it is what you are looking for.

All measures are in the sample pbix file.

I only excluded Saturday and Sunday.

I added two more people into the sample to check and test.

https://www.dropbox.com/s/zy05qjar2iqt9x3/mcrobot.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: https://www.linkedin.com/in/jihwankim1975/