Running Total per month restarting every year

[ENGFAKAYODE]

Hi Everyone,
I need your help on this,

I,ve been trying to get a running total from this table  

I didnt get how to calculate the profit per month and I want to get the running total per month restarting every year like this table:
 

If you dont get my explanation I would try and explain better

Any help would be appreciated.

https://drive.google.com/file/d/1htXjhknwwPlLUSS5YOQJFU0i6Fzvx1F5/view?usp=sharing

[MFelix · Accepted solution]

Hi @ENGFAKAYODE ,

The best option when you are dealing with dates is to create a calendar table use it in a relationship with your fact table and then create the measures based on that calendar table.

For this case you need to add the following measure:

Total YTD = TOTALYTD(CALCULATE(SUM(Orders[Profit])), 'Calendar'[Date])

See PBIX file attach.