Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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

Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi Anonymous ,

     

    One sample for your reference.

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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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

v-frfei-msft's avatar
v-frfei-msft
Community Support
7 years ago

Hi Anonymous ,

 

One sample for your reference.

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