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
| Created Date Month | Created Date Day | Reply Date Month | Reply Date Day |
| Jan | 20 | Jan | 22 |
| April | 21 | April | 25 |
| Create Date | Reply date |
| 1/2/24 905am | 1/5/24 912pm |
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?
