Forum Discussion
datediff dax -formula
this is sovled-rather than using a new measure in the report view- i used dax datediff in the data(table view) and datediff works just fine to get sla from one date compared to another (calendar days for this purpose) and can be set for hours or weeks or days-i chose days and sla achieved via dax date diff after all--closing this one as solved- thanks all
so when i use sla-datediff- it is not recognizing the columns and so instead of offering me the selection to click the table in the query to enter values for sal dax date difference instead it does nothing- same if i use datesbetween dax etc or bus day sla
Datediff requires scalar attributes. You cannot use it with columns.
oh i see tha texplains it-dax formual DateDiff is not able to leverage columns data-ok so what is simplest way to do the dax calculcation within the query or table to establish bus day or claendar day sla between the two date columns?
change your calculation to a calculated column (since the data is likely immutable) or if you need to use a measure then aggregate the data somehow, with SELECTEDVALUE or equivalent.
this is sovled-rather than using a new measure in the report view- i used dax datediff in the data(table view) and datediff works just fine to get sla from one date compared to another (calendar days for this purpose) and can be set for hours or weeks or days-i chose days and sla achieved via dax date diff after all--closing this one as solved- thanks all