Shifting forwards and backwards in time is a standard activity for Time Intelligence calculations in DAX. We have now some wonderful features; probably the most helpful is DATEADD. Let’s take an in depth have a look at it.
I’ve proven the usefulness of the DATEADD() operate in one among my previous articles:
However typically, we need to do different stuff.
For instance, we have now a hard and fast date and need to transfer it again or ahead in time.
If we need to do it for some days, it’s very simple:
For instance, I need to transfer the date 2025/01/15 10 days into the longer term:
I need to add the curly brackets as EVALUATE expects a desk, and these brackets create a desk from the output of the expression.
