3 Month Rolling Graph

[Avermaak]

Good day, 

I am experiencing some issues with a 3 month rolling graph I did, I am trying to do a 3 month rolling amount for each of the 6 first columns, per period, I have added a fiscal period Running number into my date table, but every 12 months the count restarts, and i dont want it to restart. Below some screenshots.

Could someone please help me.

This is the formula I used: 

This is the test I did to show where I get differences on the 07th and 08th Period and the 12th and 1st period. 

No need for further assistance, the fiscal running period was not pulling correctly, when I fixed it the problem was solved.

[v-yanjiang-msft]

Hi @Avermaak ,

Which column is the result based on the formula you provided, 3 Month Rolling(Revenue) or TEST?

Also, what do you mean " for each of the 6 first columns, per period", would you please explain more about it?

Best Regards,
Community Support Team _ kalyj

[Avermaak · Accepted solution]

Good day, 

So after relooking at it, I realised its the fiscal period number that was not working in my date table. I am all sorted now thank you. Just have not had an opportunity to take down the post. Apologies

Kind Regards,

[v-yanjiang-msft]

Hi @Avermaak ,

Good day.

Glad you solved the problem by yourself, if you don't have other problems, would you mide accept your solution, then we are able to close the thread. More people who have the same requirment will find the solution quickly and benefit here, thank you!

Best Regards,
Community Support Team _ kalyj