Forum Discussion

BachFel's avatar
BachFel
Icon for Helper II rankHelper II
8 years ago
Solved

Dif 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