Applying two different calendars on the same data

Hi there,

I have trouble with applying two different calendars on the same data. The sales data should be consolidated differently when it is presented to internal vs. external stakeholders.

The sales are managed by a third party agent, who is sending the line items weekly, which is then manually invoiced. This approach creates a situation when the sales for the last week of the month are being captured as revenue for the next period, but when reviewing the performance with the external stakeholder, they are interested about the sales that took place in the calendar month.

The example data looks like this:

Reporting Calendar looks like this:

Billing Calendar:

So in this case when the data is presented to the internal stakeholders, the February sales is 360 units (invoiced between week 4-7), but when it is presented to external stakeholders, the sales for the month is 330 units (shipped between week 5-8).

What is the best approach to manage this kind of situation in Power BI?

Thanks,
kukszi