PickHelper II6 years agoSolvedDATEDIFF not working Hi, Why is DATEDIFF not working below? Show Moresmpa016 years agoPick please try this DATEDIFF('Table'[Start],'Table'[End],SECOND) tkirilov6 years agoHi Pick ,You'd need to remove .[Date] from both dates, as well as have Start Date first, End date second, unless you'd like to have your answers (seconds) in negative numbers. DATEDIFF(<start_date>, <end_date>, <interval>)
smpa016 years agoPick please try this DATEDIFF('Table'[Start],'Table'[End],SECOND) tkirilov6 years agoHi Pick ,You'd need to remove .[Date] from both dates, as well as have Start Date first, End date second, unless you'd like to have your answers (seconds) in negative numbers. DATEDIFF(<start_date>, <end_date>, <interval>)
tkirilov6 years agoHi Pick ,You'd need to remove .[Date] from both dates, as well as have Start Date first, End date second, unless you'd like to have your answers (seconds) in negative numbers. DATEDIFF(<start_date>, <end_date>, <interval>)
Related contentDATEDIFF DAXDATEDIFF Working DaysDAX - DateDiff not working correctlyDateDiff Not workingDATEDIFF not working as expected