Forum Discussion
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 ...
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 I think I have found the problem. This is the table how it looks like.
| Article | Price | Delivery | Date |
| 4251203005 | 23,04 € | Express GmbH TEST | 01.07.2023 |
| 4251203005 | 23,05 € | Express GmbH TEST | 01.11.2023 |
| 4251203005 | 23,06 € | Express GmbH | 01.09.2023 |
| 4251203005 | 23,07 € | Express GmbH | 01.10.2023 |
| 4251203005 | 23,08 € | Express GmbH TEST | 01.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
Solution Sage
Solution SageAnonymous , 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