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

     

     

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    ChiragGarg2512 I think I have found the problem. This is the table how it looks like.

    ArticlePriceDeliveryDate
    425120300523,04 €Express GmbH TEST01.07.2023
    425120300523,05 €Express GmbH TEST01.11.2023
    425120300523,06 €Express GmbH01.09.2023
    425120300523,07 €Express GmbH01.10.2023
    425120300523,08 €Express GmbH TEST01.08.2023

     

    I assume the measure cannot find the entry due to the change of the name of the delivery, right? Therefore dateAdd returns NaN because there is no such entry even the date is set. 

    • ChiragGarg2512's avatar
      ChiragGarg2512
      Icon for Solution Sage rankSolution Sage
      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