Calculate the number of days between today and specific date using DAX in Powerpivot

Question

I have a date column in my data model. I want to calculate the # of days between today and the date in the column using DAX.

Thoughts?

Answer 1

You can create a calculated column with this formula:

=today()-[DATE]

and change the value of column in numeric: