Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
thx
Frequent Visitor

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. 

 

thx_0-1680883117226.png

Any help is greatly appreciated. Thanks. 

 

2 REPLIES 2
DOLEARY85
Super User
Super User

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
Super User
Super User

@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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors