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
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?
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
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.