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...

 

danextian's avatar
danextian
Super User
8 years ago

Hi BachFel

If you created  a relationship between the sum date table and your fact table, the formula will not work as the result gets filtered. Please delete the relationship and check on the  result again.