Forum Discussion
CarlBlunck
Resolver I
3 years agoA function 'PLACEHOLDER' has been used in a True/False expression that is used as a table filter exp
Hello, I am getting this error and unsure how to resolve. Have tried a solution in another post but still no luck. Original dax: Overtime hours between =
VAR StartHour = SELECTEDVALUE(...
- 3 years ago
This worked:
Overtime hours between = VAR StartHour = SELECTEDVALUE(DistinctStartingHour[Start of Hour]) VAR EndHour = SELECTEDVALUE(DistinctEndHour[End Of Hour]) RETURN IF([StartHour] > [EndHour] , --calculate overtime that crosses midnight CALCULATE([Overtime hours], FILTER(fact_TimeCardData,fact_TimeCardData[STARTTIME] >= StartHour && fact_TimeCardData[EndTimeAdjusted] <= TIME(23,59,0)) ) + CALCULATE([Overtime hours], FILTER(fact_TimeCardData,fact_TimeCardData[STARTTIME] >= TIME(0,0,0) && fact_TimeCardData[EndTimeAdjusted] <= [EndHour]) ) + CALCULATE([Overtime hours], FILTER(fact_TimeCardData,(fact_TimeCardData[STARTTIME] >= StartHour && fact_TimeCardData[EndTimeAdjusted] <= EndHour)) ) , --calculate overtime that does not cross midnight CALCULATE([Overtime hours], FILTER(fact_TimeCardData,fact_TimeCardData[STARTTIME] >= StartHour && fact_TimeCardData[EndTimeAdjusted] <= EndHour) ) )
CarlBlunck
Resolver I
3 years agoThis worked:
Overtime hours between =
VAR StartHour = SELECTEDVALUE(DistinctStartingHour[Start of Hour])
VAR EndHour = SELECTEDVALUE(DistinctEndHour[End Of Hour])
RETURN
IF([StartHour] > [EndHour] ,
--calculate overtime that crosses midnight
CALCULATE([Overtime hours],
FILTER(fact_TimeCardData,fact_TimeCardData[STARTTIME] >= StartHour && fact_TimeCardData[EndTimeAdjusted] <= TIME(23,59,0))
)
+
CALCULATE([Overtime hours],
FILTER(fact_TimeCardData,fact_TimeCardData[STARTTIME] >= TIME(0,0,0) && fact_TimeCardData[EndTimeAdjusted] <= [EndHour])
)
+
CALCULATE([Overtime hours],
FILTER(fact_TimeCardData,(fact_TimeCardData[STARTTIME] >= StartHour && fact_TimeCardData[EndTimeAdjusted] <= EndHour))
)
,
--calculate overtime that does not cross midnight
CALCULATE([Overtime hours],
FILTER(fact_TimeCardData,fact_TimeCardData[STARTTIME] >= StartHour && fact_TimeCardData[EndTimeAdjusted] <= EndHour)
)
)