Forum Discussion
Help with a measure, please.
Hello, I need to create a measue to calculate "workdays," meaning, only count M-F and non holidays. I have holidays listed in a separate data table. The goal is to: if i select an auditor, the measu...
Hi,
You could create a calculated column in report view instead of a measure and use :
Column = IF(WEEKDAY('Data'[Date]) in {1,2,3,4,5},1,0)
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍