Announcements
Hi DAXers,
int64 myint64,;
myint64 = str2int64('test');
info("result : %1" ,myint64);
I am getting 0 in info dialogue.
Can anyone please help me
Thanks
What would you want to get as a result? What are you trying to do?
You can't convert text to number. That's why you get zero.
It's only possible to convert a string that contains numbers, such as "54".
Thanks for replying.. actually i have below scenario..
int64 resourcegroup = str2int64(production.prounitid);
Here produnitid is string,it will fill as 'L1K1'
Again, L1K1 isn't a number, therefore the conversion is meaningless.
What are you trying to achieve?
Maybe it means that you have ProUnitId, which is a unique key of a table and you need RecId corresponding to this ID, but you str2int64() can't convert 'L1K1' to something like 67879890228. You'd need a query to database to obtain the additional piece of data.
Looks like you want to get RecId (int64) of some record, but at the moment you have the natural key (string). You need to use "L1K1" to search for the corresponding record from the related table (if you don't know which table to go to, you will find the table by looking at relations of the table that you have in "production" variable). Once you find this record, assign it's RecId to your "resourceGroup" variable.
Thanks a lot Nikolos...as you suggested I have assigned recid..i am able get produnitid.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Abhilash Warrier 658 Super User 2026 Season 1
André Arnaud de Cal... 632 Super User 2026 Season 1
Giorgio Bonacorsi 570
