Forum Discussion
sakuragihana
Helper IV
3 years agoMy dax is not working correctly
Hello everyone, I have a dax for counting the number of days for Monday, Tuesday, Wednesday, Thursday, Friday, Saturday Sunday at the month. DayOfTeachCount = VAR SelectedWeekStart = MIN ('Tea...
mlsx4
Memorable Member
3 years agoHi sakuragihana
You can create a kind of multiplier:
Multiplier =
SUMX('Teacher Schedule', IF('Teacher Schedule'[StartTime]="0",0,1))
And then, modify your measure:
DayOfTeachCount =
VAR SelectedWeekStart = MIN ('Teacher Schedule'[Date])
VAR SelectedWeekEnd = MAX ('Teacher Schedule'[Date])
VAR Starttime = VALUE(SELECTEDVALUE('Teacher Schedule'[StartTime]))
VAR Endtime = VALUE(SELECTEDVALUE('Teacher Schedule'[EndTime]))
VAR Result =
SUMX(
VALUES ( 'Teacher Schedule'[Date]),
SWITCH (
WEEKDAY ( 'Teacher Schedule'[Date],2),
1, IF ( 'Teacher Schedule'[Date] >= SelectedWeekStart && 'Teacher Schedule'[Date] <= SelectedWeekEnd, 1*[Multiplier], 0 ),
2, IF ( 'Teacher Schedule'[Date] >= SelectedWeekStart && 'Teacher Schedule'[Date] <= SelectedWeekEnd, 1*[Multiplier], 0 ),
3, IF ( 'Teacher Schedule'[Date] >= SelectedWeekStart && 'Teacher Schedule'[Date] <= SelectedWeekEnd, 1*[Multiplier], 0 ),
4, IF ( 'Teacher Schedule'[Date] >= SelectedWeekStart && 'Teacher Schedule'[Date] <= SelectedWeekEnd, 1*[Multiplier], 0 ),
5, IF ( 'Teacher Schedule'[Date] >= SelectedWeekStart && 'Teacher Schedule'[Date] <= SelectedWeekEnd, 1*[Multiplier], 0 ),
6, IF ( 'Teacher Schedule'[Date] >= SelectedWeekStart && 'Teacher Schedule'[Date] <= SelectedWeekEnd, 1*[Multiplier], 0 ),
7, IF ( 'Teacher Schedule'[Date] >= SelectedWeekStart && 'Teacher Schedule'[Date] <= SelectedWeekEnd, 1*[Multiplier], 0 ),
BLANK ()
)
)
Return Result - sakuragihana3 years ago
Helper IV
- mlsx43 years ago
Memorable Member
But why 10? Because of Saturdays and Sundays?
- sakuragihana3 years ago
Helper IV
Hi mlsx4 ,
You can see data in power BI file , the Friday that teacher have no schedule .