I guess I was looking for a more automated solution, I found it odd that PowerBi does not have a calendar function built in. Given that Outlook is an MS updated calendar at regional levels.
I suppose coming from Tableau and others like it, I expected it to be an included functionality. I understand holidays might be harder to work out, but I would have thought weekdays to be more straigt forward.
Ill keep diggin and if i find anything of use ill post it back here.