Notifications
Announcements
No record found.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 451 Most Valuable Professional
André Arnaud de Cal... 428 Super User 2025 Season 2
BillurSamdancioglu 239 Most Valuable Professional
