Hi Experts ,
i am trying to convert text to numeric by using dax function
but it is not working ,pls suggest me
1 ACCEPTED SOLUTION
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.
| Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |
| If you found this post helpful, please give Kudos. It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen. If you find my signature vaguely amusing, please give Kudos. | Proud to be a Super User! |
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.
| Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |
| If you found this post helpful, please give Kudos. It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen. If you find my signature vaguely amusing, please give Kudos. | Proud to be a Super User! |
Helpful resources
Fabric Community Update - July 2025
Find out what's new and trending in the Fabric community.
Power BI Monthly Update - July 2025
Check out the July 2025 Power BI update to learn about new features.
