David Hager on 04 Mar 2015 03:00:04
What would really be useful is this: to be able to tell Power Query to EVALUATE based on desired source syntax, whether it be Excel, PowerPivot (DAX) or SQL. It would work like automation, but only get the appropriate “formula” engine. Something like Expression.Evaluate(FormulaEvaluator.PowerPivotAddin(“MyDAXFormula”)).