Can I actually add 2-4 numbers that are coded to one column by splitting the column?

[Karolina411]

Hello Super Dax Greatness:

Due to some hectic permutations of productivity Matrix SQL I get a column with 

1, 2, 3 and sometimes 4 entries related to 1 encounter.  I wish to sum them--can I do that using DAX somehow and splitting the column by the | as shown below?

Thanks!

[bolfri · Accepted solution]

In the Power Query M editor add custom column:

List.Sum(
    List.Transform(
        Text.Split([C_time], "|"), 
        each Number.FromText(_)
        )
    )

It will work for any splitter it founds (see last row)

[Karolina411]

I tried to split on the | --I could not somehow--then I would simply sum the two columns---

[Ahmedx]

or do you need it?

[Ahmedx]

Is this what you are looking for?

[Karolina411]

Yes--indeed--to sum them together---It's a complex issue and I had to use the WITHIN GROUP SQL function to make it work.

[Ahmedx]

see attached
https://1drv.ms/u/s!AiUZ0Ws7G26RhhJE4oV-8WzGvFDA?e=dwT5xE