Calculate the YTD Revenue and Previous YTD Revenue

[mspanic]

Regarding Time Intelligence prerequisites Melissa made such great explanation in serial of posts + provide code.

Maybe you can start from:

Extended Date Table (Power Query M function)

Hi @surpat, For Time Intelligence functions to work there are some requirements, you can find them in this recent post. Do I really need a full year in my Date table? - #2 by Melissa Alternatively I would suggest not creating a relationship between the Date- and Fact table but using TREATAS to create that relationship virtually since the granularities between the tables don’t match. As @Greg mentioned, if you have need of further assistance please create a new thread and provide all relevant…

and follow the links.

Good luck.