Forum Discussion

BachFel's avatar
BachFel
Helper 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
Helper II
8 years ago

That there are to less arguments for using the if-function.

This is caused by the reason that I´m not able to find the table Datumstabelle I guess..

vanessafvg's avatar
vanessafvg
Community Champion
8 years ago

BachFel show me how you adjusted the formula?

  • BachFel's avatar
    BachFel
    Helper 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
    Community 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