Forum Discussion
How to SUM text fields
Hi,
I have table like below.
This is an example of a request's data. There will be diffrent types of requests. Each can have variable number of fields.
The request is a separate table which has a relationship to the above fields table. From the example above, I need to create a measure showing the total number of claims and total receipt.
Problem: Since my field value is a text coumn. I can't directly take the Sum of that column. I tried below. That did not work. Please help.
** Request Type is a dimension table having all the requests types
meeradominic , In power query separate out text and non text rows and then create a measure
3 Replies
meeradominic , In power query separate out text and non text rows and then create a measure
Amit could you throw some light on how I can split number & text in power Query?
amitchandak I duplicated the field_value column and changed the type of the column to decimal. And replaced all the errors with null. This resolved my issue. Thanks!!
