Forum Discussion

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

datedif Function, only for working days (mon-Fri)

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]<>BLA...
Need Help
  • danextian's avatar
    danextian
    8 years ago

    Did you use a disconnected table?

vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
8 years ago

BachFel i would create a flag for the working days, ie a new column calls isworkingday = 1

 

and then use that in your calculation