Forum Discussion

Mahamood0218's avatar
Mahamood0218
Icon for Helper II rankHelper II
4 years ago
Solved

Need to convert text to numeric in power bi dax function

Hi Experts ,

 

i am trying to convert text to numeric by using dax function 

but it is not working ,pls suggest me

 

 

 

 

 

 

Need Help
Show and Tell
Tips and Tricks
  • KNP's avatar
    KNP
    4 years ago

    Probably better to do it in Power Query, but if you want to do it as a calculated column, you could try...

    Days Commit2 = IF('Table'[Days_Commit] = "", BLANK(), VALUE('Table'[Days_Commit]))

     

    Replace 'Table' with your table name.

     

3 Replies

  • KNP's avatar
    KNP
    Icon for Super User rankSuper User
    4 years ago

    Probably better to do it in Power Query, but if you want to do it as a calculated column, you could try...

    Days Commit2 = IF('Table'[Days_Commit] = "", BLANK(), VALUE('Table'[Days_Commit]))

     

    Replace 'Table' with your table name.

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Can you show an example of what the text look like so we can suggest the right solution?