Cannot convert value " of type text to number

[chiru5262]

Can anyone please advise how to solve this

Thanks

[Anonymous · Accepted solution]

Hi @chiru5262 ,

First of all thanks to Ashish_Mathur  for the quick reply and solution. I have some other ideas for you to consider:

(1) This is my test data. 

(2) You can use the following DAX：

Table 2 = 
VAR Table2 =
    SELECTCOLUMNS (
        FILTER ( FACT_WORKORDER, [ORIGRECORDID] <> BLANK () ),
        "Wo num table1", VALUE ( 'FACT_WORKORDER'[ORIGRECORDID] ),
        "Wo num table2", VALUE ( 'FACT_WORKORDER'[Wonum] )
    )
RETURN
    Table2

(3) Then the result is as follows.

Best Regards,

Neeko Tang

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

[Ashish_Mathur]

Hi,

In the Power Query Editor, ensure that the data type of the Wonum and Origrecordid columns is number.