Exclude 5 & 6 in weekday column, hopefully easy

[Ttaylor9870]

Hey Experts!

I have the below custom column...

= [Target]/Date.DaysInMonth([Date])

But I would like to exclude day 5 & 6 in my [Weekday] column. Basically, before the equation above is performed so I'm getting Target divded by days in month minus weekdays 5 & 6.

(End goal is daily target minus weekends)

Any help would be greatly appreciated!!😁

Many Thanks,

Taylor

[kleigh]

I found a community blog with a custom function to do this:
Date.Networkdays function for Power Query and Powe... - Microsoft Fabric Community