Help with a measure, please.

[thx]

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 measure would calculate how many work days the auditor had within the date range. 

Any help is greatly appreciated. Thanks. 

[DOLEARY85]

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 👍

[amitchandak]

@thx , Something like this

networkdays(min(Table[Action date]), Max(Table[Action Date]) , 1)

Learn Power BI Advance- 90 :Power BI - Business day with and without using DAX Function NETWORKDAYS
Power BI - Business day with and without using DAX Function NETWORKDAYS: https://www.youtube.com/watch?v=Qs03ZZXXE_c