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.

     

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?