Transferring backwards and forwards in time is a standard activity for Time Intelligence calculations in DAX. We now have some glorious features; one of the crucial helpful is DATEADD. Let’s take an in depth have a look at it.
I’ve proven the usefulness of the DATEADD() perform in certainly one of my previous articles:
However generally, we need to do different stuff.
For instance, now we have 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 straightforward:
For instance, I need to transfer the date 2025/01/15 10 days into the longer term:
I have to add the curly brackets as EVALUATE expects a desk, and these brackets create a desk from the output of the expression.