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

vanessafvg

 

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

 

I´m not able to select the table Datumstabelle where the row AlleDaten is in...

I created a relationship as u mentioned but it won´t work.. I´m lost...

 

vanessafvg's avatar
vanessafvg
Community Champion
8 years ago

BachFel

it looks like the relationship has been created, what error you getting?

  • 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