Forum Discussion

PwrBI01's avatar
PwrBI01
Post Patron
5 years ago
Solved

Calculation error in measure: Function 'DATEADD' expects a contiguous selection when the date column

Hi guys,   I am trying to create a measure to calculate the variation between 2 years with the following measure: Expenses variation = Var CurrentExpenses = TOTALYTD(SUM(Sales[Sales]);'Calendar ...
Need Help
  • PwrBI01's avatar
    PwrBI01
    5 years ago

    Hi v-janeyg-msft,

     

    Thank you for your answer.

     

    I was creating a simple data and I have found were the problem was.

     

    I had a not activated relationship between Calendar table [Year] and another table with a both direction filter. When I changed that into single direction filter the problem was solved.

     

    Regards.

amitchandak's avatar
amitchandak
Super User
5 years ago

PwrBI01 , Mark Calendar table as a date table, That will check for any issue with noncontinuous dates. Right-click on the table there is an option 

Also, Try like

CALCULATE(TOTALYTD(SUM(Sales[Sales]);DATEADD('Calendar table'[Sales];-12;MONTH)))

PwrBI01's avatar
PwrBI01
Post Patron
5 years ago

Hi amitchandak,

 

Thank you for your answer, I have tried both ways but it doesn't work.

 

Regards.