Forum Discussion
BachFel
8 years agoHelper II
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...
- 8 years ago
Did you use a disconnected table?
BachFel
8 years agoHelper II
Hi danextian,
i created a calender table where weekdays have a 1 and sat/ sun has a 0. This column in is the table called:
Datumstabelle[IsWorkingDay]
then I added your second formula. But the result is wrong.
I´m not sure about: DATESBETWEEN (Datumstabelle[Daten]. This is the column in my calender with all possible dates.
I´ve no clue where the mistake could be
danextian
8 years agoSuper User
Did you use a disconnected table?