Hi @annamarie,
First you’ll need a proper Date table to perform any Time Intelligence calculation…
Please incorporate that into your model
Here’s a link to the Extended Date table M code function.
Next I would suggest to work through these courses.
and
I hope this is helpful
1 Like