You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Reviewing the data types specification, it does not appear that a simple numeric array (i.e. floating point vector, matrix, etc.) is included.
Numeric arrays (and matrices in particular) are invaluable for example in Matlab, R, Python (via NumPy) and Julia, and this data type would help Power FX realise its potential as a general purpose programming language - opening up possibilities in science and engineering domains.
The recent addition of support for dynamic arrays in Excel (along with associated functions such as sequence, randarray, unique, sortby) has been a real breakthrough, hugely increasing the utility of Excel in technical computing. Given that Excel users will increasingly begin to rely on dynamic arrays it seems natural for this functionality to be replicated in Power FX.
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
Reviewing the data types specification, it does not appear that a simple numeric array (i.e. floating point vector, matrix, etc.) is included.
Numeric arrays (and matrices in particular) are invaluable for example in Matlab, R, Python (via NumPy) and Julia, and this data type would help Power FX realise its potential as a general purpose programming language - opening up possibilities in science and engineering domains.
The recent addition of support for dynamic arrays in Excel (along with associated functions such as sequence, randarray, unique, sortby) has been a real breakthrough, hugely increasing the utility of Excel in technical computing. Given that Excel users will increasingly begin to rely on dynamic arrays it seems natural for this functionality to be replicated in Power FX.
Beta Was this translation helpful? Give feedback.
All reactions