Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Measure with DateAdd returns NaN

Hi there, I`m struggling with the measure dateAdd which delivers NaN, which I don´t understand. The value in the table which I am searching for looks like this: The measure which I am using ...
  • ChiragGarg2512's avatar
    ChiragGarg2512
    2 years ago

    Anonymous , if there is only price and valueprevmonth, there is no way of distinction. For each product the valueprevMonth will be different. If delivery name is added to table visual, the measure will look like this

     

     

ChiragGarg2512's avatar
ChiragGarg2512
Icon for Solution Sage rankSolution Sage
2 years ago

Anonymous , If [price] is a column, then try changing the dax to 

 

ValuePrevMonth = (CALCULATE(sum('Table'[Price]), DATEADD('Table'[Date],-1, MONTH)))

 

Thank you

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Thanks, but price is already a measure with sum(table[price]), my fault, I should have added this as information.

    • ChiragGarg2512's avatar
      ChiragGarg2512
      Icon for Solution Sage rankSolution Sage
      2 years ago

      Anonymous , Check the data type of date column. The dax seems to work fine

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        ChiragGarg2512 The data type of the column is already from kind date. I´m wondering if I need an index or sth like that?