The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
I'm pulling data from an excel file in SQL server where furmulas are appearing as text and not a claculated numbers.
Can I convert those text formulas into calculated values without writing a complex code?
(Strings lenght are not constant and numbers are different per each cell)
See below example:
Appriciate the help 🙂
Yoav.
Solved! Go to Solution.
@arbelyoav Try Expression.Evaluate in Power Query
https://docs.microsoft.com/en-us/powerquery-m/expression-evaluate
It Works!!
Thanks Amitchandak
@arbelyoav Try Expression.Evaluate in Power Query
https://docs.microsoft.com/en-us/powerquery-m/expression-evaluate