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?

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

Tage_seit_erster_Objektbegung =
IF (
    ISBLANK (KontElemente[Datum der Besichtigung]);
    BLANK ();
    IF(Datumstabelle[AlleDaten]) = 1; DATEDIFF (KontElemente[Datum der Besichtigung]; TODAY (); DAY ); BLANK () )

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

BachFel i meant the formula i gave you?  have  you adjusted it to your model?  secondly you need to use the date table not the other table