Forum Discussion

miguelHG's avatar
miguelHG
Frequent Visitor
5 years ago
Solved

Help with this problem

It is a very simple topic, but I can't find the solution, I need to set the days between 2 dates, try "Datediff", but it asks for the dates, but when I write the field, the program does not take it:

 

 

I also tried to create a measure in another table that pulls the date that I need, but I couldn't, can someone help me? Thanks

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi miguelHG 

    Are you sure your fields are Date or DateTime fields? I used this formula to test and it works fine:
    CalculatedColumn:

    Datediff = DATEDIFF('Table'[DocDate],'Table'[DocDueDate],DAY)

    And for a measure:

    DateDiffMeasure = DATEDIFF(SELECTEDVALUE('Table'[DocDate]),SELECTEDVALUE('Table'[DocDueDate]),DAY)


     Result:

     

    Eric.  

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi miguelHG 

    Are you sure your fields are Date or DateTime fields? I used this formula to test and it works fine:
    CalculatedColumn:

    Datediff = DATEDIFF('Table'[DocDate],'Table'[DocDueDate],DAY)

    And for a measure:

    DateDiffMeasure = DATEDIFF(SELECTEDVALUE('Table'[DocDate]),SELECTEDVALUE('Table'[DocDueDate]),DAY)


     Result:

     

    Eric.