2

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?

FoxyB
  • 41
  • 2
  • 3
  • 10

1 Answers1

3

You can create a calculated column with this formula:

=today()-[DATE]

and change the value of column in numeric:

enter image description here

Pierre.Vriens
  • 2,117
  • 75
  • 29
  • 42
nicolò grando
  • 397
  • 1
  • 9