Date diff function is not recognising the date columns from the table

[Anonymous]

[SteveCampbell]

If this is a measure, you need to give it some type of context. Right now, you are reffering to a whole column, so it does not know which value in the column to use.

If you plan on using this in a table or graph, using the function "Selectedvalue" will add the current context.

Try this:

DURATION = 
   DATEDIFF(
           SELECTEDVALUE(sai_duedate) ,
           SELECTEDVALUE(sai_startdate) ,
           day
   )

[Anonymous]

Thanks Steve , I want to apply it on row level . Will this work ?

[v-frfei-msft · Accepted solution]

Hi @Anonymous ,

One sample for your reference.

DURATION = 
DATEDIFF ( MAX ( 'Table'[sai_startdate] ), MAX ( 'Table'[sai_duedate] ), DAY )