DateDiff DAX Error

[chaitanyajiwani]

I have to create the datediff between the 'project from date' and 'today' in days. 
However I am not able to specify 1st date parameter column.

Is there a way I can calculate difference between 2 dates?

[v-yadongf-msft]

Hi @chaitanyajiwani ,

Has your problem been solved? If solved, please consider Accept it as the solution to help the other members find it more quickly.

[v-yadongf-msft · Accepted solution]

Hi @chaitanyajiwani ,

There are two solutions:

1.Please create a new column:

Column = DATEDIFF('Table'[project from date],TODAY(),DAY)

2.Please create a new measure:

gap = DATEDIFF(MAX('Table'[project from date]),TODAY(),DAY)

Best regards,

Yadong Fang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Tahreem24]

@chaitanyajiwani ,Try this

DATEDIFF(TableName[Proj Start Date Column],Today(),DAY)

[chaitanyajiwani]

I tried that, but I am not able to add the first date parameter is i.e. 'Project From Date' column.

[tamerj1]

Hi @chaitanyajiwani 
Please try
DATEDIFF ( SELECTEDVALUE ( TableName[Proj Start Date Column] ),  Today ( ), DAY )