Beginning Backlog Calculation with Non-Standard Calendar (445)

[Silvio]

Hi everyone,
I’m working to solve and populate a quarterly schedule for ending balance by week with also utilizes a non standard calendar (445) Essentially, the last day of the quarter’s revenue is called “Beginning Backlog” for the next quarter. This beginning backlog is separated out in the quarterly/week schedule. Below is a sample a screenshot of what it should look like:

In this example, the last day of Q4 2020 was Jan 2, 2021. The beginning backlog should be around $52.5M. and be reflected in the Beginning Backlog row but instead it appears on the 14th week of the quarter. Attached is a sample file.

I am looking for the correct dax formula to populate the week table for their corresponding figures for week and begging backlog balance which is the last day from the previous quarter. Any ideas?

Any help would be greatly appreciated.

Thanks.

S.
Weekly-Quarterly Revenues_Sample_v3.pbix (6.5 MB)

[EnterpriseDNA]

Hi @Silvio! We noticed that your inquiry was left unsolved for quite some time now. We strive to answer ALL inquiries in the forum. However, if you are sure that you provided all pertinent context to your concerns and read how to use the forum more effectively and still find your question unanswered, you can check out tutorials to learn this yourself as your membership also comes with relevant resources that may help you with your Power BI education.

While our users and experts do as much as reasonable to help you with your inquiries, not all concerns can be attended to especially if there are some learnings to be done. Thank you!