Forum Discussion

Archiedog1's avatar
Archiedog1
New Member
2 years ago
Solved

calulating totals with ; semi colon

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's avatar
    Anonymous
    2 years ago

    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.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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's avatar
    sjoerdvn
    Icon for Solution Sage rankSolution Sage
    2 years ago

    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.