Dif between two dates without weekend & public holidays

[BachFel]

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

[Greg_Deckler · Accepted solution]

Use my Net Work Days Quick Measure:

https://community.powerbi.com/t5/Quick-Measures-Gallery/Net-Work-Days/m-p/367362