Forum Discussion
BachFel
Helper II
8 years agoDif between two dates without weekend & public holidays
Hello,
follwing problem.
I want to create a DAX formula which shows the difference from a specific date to today.
Tage_seit_erster_Objektbegung = if(KontElemente[Datum der Besichtigung]<>BLANK();
TODAY()-KontElemente[Datum der Besichtigung].[Date];
BLANK())
Is it possible to count only the working days (monday-Friday) except public holidays
Thanks in advance
Use my Net Work Days Quick Measure:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Net-Work-Days/m-p/367362
1 Reply
- Greg_Deckler
Community Champion
Use my Net Work Days Quick Measure:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Net-Work-Days/m-p/367362