Forum Discussion

Regular Visitor

6 years ago

Solved

Building Excel WORKDAY-Function in Power BI

Hi everyone, I need a function in PowerBI, which provides the same features like the WORKDAY-function in excel. So I want to add several days to a date in consideration of weekends and holidays. ...

amitchandak
6 years ago
lk94 , refer if these can help

https://community.powerbi.com/t5/Desktop/WORKDAY-formula-in-Power-BI/td-p/202383
https://community.powerbi.com/t5/Desktop/Number-of-working-days/td-p/22842
https://www.youtube.com/watch?v=kRACuS4eKWA

Or refer 2nd page of this file

https://www.dropbox.com/s/y47ah38sr157l7t/Order_delivery_date_diff.pbix?dl=0

Greg_Deckler

Community Champion

6 years ago

lk94 - Check out Net Work Days - https://community.powerbi.com/t5/Quick-Measures-Gallery/Net-Work-Days/td-p/367362

Also, Excel to DAX Translation - https://community.powerbi.com/t5/Community-Blog/Excel-to-DAX-Translation/ba-p/1060991

Finally since I see you are a New Member some additional useful links:

https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Forum Discussion

Building Excel WORKDAY-Function in Power BI

Related content

Function - get previous workday date

Analyze in Excel - Build rights

WorkDays Function in Power Query M

DAX Workday Function

direct application of WORKDAY function like in excel