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
Microsoft Fabric Learn Together
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Power BI Monthly Update - April 2024
Check out the April 2024 Power BI update to learn about new features.
Fabric Community Update - April 2024
Find out what's new and trending in the Fabric Community.
