Forum Discussion
Key
I think you might be are out of luck there, M functions "update" when evaluated. If you need a "static" value that will have to be provided by a datasource. For example, the date/time a file or an export was created and so on.
Depending on your scenario and its complexity, you could generate a list or column of values (indices) from which you take the first "free" number...
Thanks again m_dekorte, really appreciate your help. At least I know now I am not going mad.
I am using the datetime as I want to generate a key that is unlikely to be replicated. Any suggestions as to how I can generate something unique out a function that will remain 'static' ?
I think you might be are out of luck there, M functions "update" when evaluated. If you need a "static" value that will have to be provided by a datasource. For example, the date/time a file or an export was created and so on.
Depending on your scenario and its complexity, you could generate a list or column of values (indices) from which you take the first "free" number...
Many thanks for your help m_dekorte.