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 , 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