ENGINEERING PROGRESS GRAPH

Hi  cstamp76 ,

Here are the steps you can follow：

1. Select the 6 columns – Transform – Unpivot Columns.

2. Create calculated column.

Table1 =
VAR _COLUMN=
{"HISTO","LINE"}
VAR _TABLE1=
DISTINCT('Table'[Attribute])
RETURN
CROSSJOIN(
    _TABLE1,_COLUMN)

3. Create calculated column.

Sep - 22 =
SWITCH(
    TRUE(),
    'Table1'[Value]="HISTO",
    SUMX(
        FILTER(ALL('Table'),
       'Table'[Attribute]='Table1'[Attribute]&& YEAR('Table'[Value])=2022&&MONTH('Table'[Value])=9),[QTY(TONS)]),
    'Table1'[Value]="LINE",
     SUMX(
        FILTER(ALL('Table'),
      'Table'[Attribute]=EARLIER('Table1'[Attribute])&& 'Table'[Value]<=EOMONTH(DATE(2022,9,1),0)),[QTY(TONS)]))

Oct - 22  =
SWITCH(
    TRUE(),
    'Table1'[Value]="HISTO",
    SUMX(
        FILTER(ALL('Table'),
       'Table'[Attribute]='Table1'[Attribute]&& YEAR('Table'[Value])=2022&&MONTH('Table'[Value])=10),[QTY(TONS)]),
    'Table1'[Value]="LINE",
     SUMX(
        FILTER(ALL('Table'),
      'Table'[Attribute]=EARLIER('Table1'[Attribute])&& 'Table'[Value]<=EOMONTH(DATE(2022,10,1),0)),[QTY(TONS)]))

Nov - 22 =
SWITCH(
    TRUE(),
    'Table1'[Value]="HISTO",
    SUMX(
        FILTER(ALL('Table'),
       'Table'[Attribute]='Table1'[Attribute]&& YEAR('Table'[Value])=2022&&MONTH('Table'[Value])=11),[QTY(TONS)]),
    'Table1'[Value]="LINE",
     SUMX(
        FILTER(ALL('Table'),
      'Table'[Attribute]=EARLIER('Table1'[Attribute])&& 'Table'[Value]<=EOMONTH(DATE(2022,11,1),0)),[QTY(TONS)]))

4. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly