Forum Discussion

thx's avatar
thx
Frequent Visitor
3 years ago

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

 

Any help is greatly appreciated. Thanks. 

 

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    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

  • DOLEARY85's avatar
    DOLEARY85
    Resident Rockstar
    3 years ago

    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 👍