Forum Discussion
DateDiff DAX Error
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...
Hi Anonymous ,
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.
Hi Anonymous ,
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.