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?

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

        Anonymous , can some sample data for 10 to 12 rows be provided in tabular form. There shouldn't be a need to create a new column.