MTD per week for Forecast, Business Plan, Sales and Packed

[HarCopy]

Good day

I need to create a line and clustered column chart for the MTD per week of the Forcast, Business Plan, Sales and Packed. We are using a 445 Fiscal Year starting with the first week of July, so the DAX functions doesn't work.

Below is an example of the data table.

FinYear&Week	Description	Volume	Month
201944	FC	1220.82	May
201944	BP	1456.57	May
201944	Sales	1563.01	May
201944	Pack	1803.78	May
201945	FC	1475.87	May
201945	BP	1456.57	May
201945	Sales	2245.78	May
201945	Pack	2137.76	May
201946	FC	1200.85	May
201946	BP	1456.57	May
201946	Sales	491.725	May
201946	Pack	500.625	May
201947	FC	1443.84	May
201947	BP	1456.57	May
201947	Pack		May
201947	Sales		May
201948	FC	1378.44	Jun
201948	BP	1432.23	Jun
201948	Sales		Jun
201948	Pack		Jun
201949	FC	1396.78	Jun
201949	BP	1432.23	Jun
201949	Sales		Jun
201949	Pack		Jun
201950	FC	1159.57	Jun
201950	BP	1432.23	Jun
201950	Sales		Jun
201950	Pack		Jun
201951	FC	1094.12	Jun
201951	BP	1432.23	Jun
201951	Pack		Jun
201951	Sales		Jun
201952	FC	1632.47	Jun
201952	BP	1432.23	Jun
201952	Pack		Jun
201952	Sales		Jun

Here is an Excel example of the graphExcel Example of Graph

[TeigeGao]

Hi @HarCopy ,

In your scenario, we cna use the following DAX query:

MTD =
CALCULATE (
    SUM ( Table1[Volume] ),
    FILTER (
        ALLEXCEPT ( Table1, Table1[Description] ),
        Table1[Month] = MIN ( Table1[Month] )
            && Table1[FinYear&Week] <= MIN ( Table1[FinYear&Week] )
    )
)

The result will like below:

Best Regards,

Teige