Moving back and forth in time is a common task for Time Intelligence calculations in DAX. We have some excellent functions; one of the most useful is DATEADD. Let’s take a detailed look at it.
I have shown the usefulness of the DATEADD() function in one of my past articles:
But sometimes, we want to do other stuff.
For example, we have a fixed date and want to move it back or forward in time.
If we want to do it for some days, it’s very easy:
For example, I want to move the date 2025/01/15 10 days into the future:
I must add the curly brackets as EVALUATE expects a table, and these brackets create a table from the output of the expression.