calulating totals with ; semi colon

[Archiedog1]

Hi I have a data set from sql - i need to create a graphic that combines and makes a total 

currently the cell has multiple numbers seperated with a ; e.g - 1000; 100; 200

i need a new column that combines these values to be 1300.

thanks

[Anonymous · Accepted solution]

Hi @Archiedog1 ,

I create a table as you mentioned.

Then I use Split Column and select By Delimiter.

Next I change type to the Whole Number.

Finally I create a Custom Column.

Number.Abs([Example.1]) + [Example.2] + [Example.3]

Finally you will get what you want.

Best Regards

Yilong Zhou

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

[sjoerdvn]

Technically you could do this in dax, but since your data source is SQL you are better off solving that in SQL, or alternatively in Power Query.