Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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

  • Hi Anonymous ,

     

    One sample for your reference.

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

3 Replies

  • SteveCampbell's avatar
    SteveCampbell
    Memorable Member

    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's avatar
      Anonymous
      Not applicable

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

      • v-frfei-msft's avatar
        v-frfei-msft
        Community Support

        Hi Anonymous ,

         

        One sample for your reference.

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