Forum Discussion
Dateadd not working as expected
Using dateadd but it's not returning the expected value. Trying to get the sum of qty sold from the same period last year, however, this calculation is returning value on the saem period of the year....
Pady
Helper II
Helper IIPlease create a Date table and an YearMonth column in the Date table and create a relationship with the table containing quantity and use the Measure shown in the screenshot below:
I created a table (from 1/1/2021 to 12/31/2024) as instructed, and created the relationship between two tables, however, when I put them into one table, it gave me this result.