Can't get SUMX on GENERATESERIES to work

[BaileyL]

Hello,

I simply want the DUPLICATE_INDEX to represent how many of the numbers should be added together from PLANNING. This can't be hardcoded, the length of PLANNING can be 100+ digits and go from 1-999. If theres a better way feel free.

Current Output
DUPLICATE_INDEX, PLANNING, OUTPUT
1, "1,3,1", 131
2, "1,3,1", 131
3, "1,3,1", 131

Expected Output
DUPLICATE_INDEX, PLANNING, OUTPUT
1, "1,3,1", 1                  (1)
2, "1,3,1", 4                  (1+3)
3, "1,3,1", 5                  (1+3+1)

Code:

DAYS_TO_ADD =
VAR DigitsTable =
ADDCOLUMNS(
GENERATESERIES(1, PATHLENGTH([PLANNING])),
"Digit",
VALUE(PATHITEM([PLANNING], [Value]))
)
RETURN SUMX(FILTER(DigitsTable,
[Value] <= [DUPLICATE_INDEX]
),
[Digit]
)

Many Thanks, 

Bailey. 

[bhanu_gautam]

@BaileyL , Try using below DAX

DAYS_TO_ADD =
VAR DigitsTable =
ADDCOLUMNS(
GENERATESERIES(1, PATHLENGTH([PLANNING])),
"Digit",
VALUE(PATHITEM([PLANNING], [Value]))
)
RETURN
SUMX(
FILTER(
DigitsTable,
[Value] <= [DUPLICATE_INDEX]
),
[Digit]
)

[BaileyL · Accepted solution]

Update : I used PowerQuery to get the same result. The code may not be useful, but it did the job. 

= Table.AddColumn(#"ADD COMMAS TO PLANNING", "Duplicates", each
let
count = if [PLANNING] = "" then 0 else List.Count(Text.PositionOf([PLANNING], ",", Occurrence.All)) + 1,
dup_index = List.Transform({1..count}, each _)
in
dup_index
)

[BaileyL]

Hi,

This doesn't seem to work. The output is still 131. Thank you though.