March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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....,
Solved! Go to 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.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
9 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
17 | |
4 | |
4 | |
3 | |
3 |