DAX for Calculating the number of days from Today()

[Anonymous]

I have a Due Date field.  I want to add a column that displays the result as the number of days remaining to due date.

I'm trying DATEDIFF(Table_Name[Due_Date], TODAY() , DAY)

I've tried a number variations but can't get it operational.  Any ideas?

Also, if Due_Date has already past I want the result to show as <negative> 

[Jif]

Hi Peekay44,

I used in  my Date's Table like this :

 INT( [Date] ) - INT( Today() )

where [Date] is like Table_Name[Due_Date]  

I returns a number ( positive or negative ) 

Regards,

Julio

[Anonymous]

Did you use "Custom Column" from Add Column tab ?

[Jif]

Hi Peekay44,

I used it on a own Date's table:

[aj1973]

Hi @Anonymous 

Due_Date field must be in a Date Format, is it?

[Anonymous]

Yes, indeed

[aj1973]

Can you share a sample please? or a screenshot