Help with this problem

[miguelHG]

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

[Anonymous · Accepted solution]

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.