SUM TEXT FIELD FROM DIFFERENT TABLES

[Shashank294]

Please someone help me with this.

I have text fields in 3 different tables, now i want to sum this text field.

eg:Table1-->Column1

                    ABCD123E

                    WERA231C

     Table2-->Column1

                   FGHA456X

                   NSDW234A

     Table3-->Column1

                   TYREK123Q

                   NSDW234A

I would like to thank you in advance....,

[v-chenwuz-msft · Accepted solution]

Hi @Shashank294 ,

I command you to use Power Query to get the number in the text.

First, append these table and use split column by digit to non-Digit to get the number in the text.

Split columns by digit to non-digit - Power Query | Microsoft Docs

Then use dax sum() to calculate the number.

Pbix in the end you can refer.

Best Regards

Community Support Team _ chenwu zhu

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