Forum Discussion

diogobraga2's avatar
diogobraga2
Helper IV
6 years ago
Solved

Calculate Date Difference

The goal is to create a measure of the difference between any date on the Date column and 10/01/2020. I am getting an error on the first step...not sure why the calculation is not accepting the Date ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    diogobraga2 - Try:

     

    Days to 10/01/2020  = (DATE(2020,10,1) - 'Daily Trend'[Date]) * 1.

     

    Or 

     

    Days to 10/01/2020  = (DATE(2020,10,1) - MAX('Daily Trend'[Date])) * 1.