AI14Helper III3 years agoSolvedif statement time Hi my measure doesnt seem to work. i want to show a 1 if the task duration is less than the clean sla. Task duarion is a measure that does outbound_st - sta & Clean SLA is a column i manua...Show Moretamerj13 years agoHi AI14 try test01 = IF( TIMEVALUE ( [TaskDuration] ) < SUMX(clean,clean[Clean SLA]),1)
tamerj13 years agoHi AI14 try test01 = IF( TIMEVALUE ( [TaskDuration] ) < SUMX(clean,clean[Clean SLA]),1)
tamerj13 years agoHi AI14 try test01 = IF( TIMEVALUE ( [TaskDuration] ) < SUMX(clean,clean[Clean SLA]),1)
tamerj1Community Champion3 years agoHi AI14 try test01 = IF( TIMEVALUE ( [TaskDuration] ) < SUMX(clean,clean[Clean SLA]),1)
AI14Helper III to tamerj13 years agosame result all showing 1 even uf its less or more tamerj1Community Champion to AI143 years agoAI14 which column are you using to slice by in this table visual and from which table? AI14Helper III to tamerj13 years agoworked, i added timevalue to both sections
tamerj1Community Champion to AI143 years agoAI14 which column are you using to slice by in this table visual and from which table?
Related contentOR Statement ?SQL Statement opcion errorIF Statements For Date and TimeIF statement for Time in DAXTime vs Time Scatter Chart
