Practical Challenge 2 DAX

Let’s consider a situation where the Date table spans from January 1, 2020, to December 31, 2022. A new calculated column is added to the table with the formula DateAdd([Date], -1, Year).

Now, if we focus on a specific row where the value in the Date column is January 1, 2020, what date will be returned after applying this calculation?

In this case, the result will be blank. The DateAdd function requires a continuous sequence of dates, and since there is no date prior to January 1, 2020, the expected date of January 1, 2019, cannot be generated.