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....
efeng2023 two issues:
why do you have cross filter direction set to both
also, make sure you mark the date table as a date table.
1. The corss relationship between two tables are set by the system when I connected them
2. The Dates table is marked as a date table