ROLLING SUM Based on Months in 445 Fiscal Calendar - PLEASE HELP

[Anonymous]

This has stumped me for hours now. My company runs on a 445 fiscal calendar and I cannot get my monthly rolling sum to continue based on date because my fiscal months are 445. In other words, each month begins 3/4 of the way through the month  prior. For example, the fiscal month of September started on August 22nd and will end on September 25th. 

What can I do to get a rolling sum that begins on the first day of the fiscal month and continues to the end of the fiscal month ignoring the actual date changes from one calendar month to the next? See sample data below:

[v-jayw-msft]

Hi @Anonymous ,

Can you create a fiscal date column and calculate ROLLING SUM based on this column?

Best Regards,

Jay

[Fcoatis]

@Anonymous This might help: Link 

Regards

[Anonymous]

I'm still struggling with this. Anyone have a magic DAX expression or a couple lines of M-language to write a custom solution?

[Fcoatis · Accepted solution]

@Anonymous Maybe this will help you create a custom 445 Calendar. then use it as a reference for runningtotal.

It will help if you upload a sample data showing how exactly your calendar should be. As well as the desired running total

Regards