Showing results for 
Search instead for 
Did you mean: 
Pfister Established Member
Established Member

Re: Dax or M Language

.. Your answer is correct. At the moment.

But please consider SQL vNExt, which is in CTP and will be released this year.

SQL vNExt supports Power Query!



Greetings Hp Pfister
Power Query Buch online auf
DoubleJ Member

Re: Dax or M Language

Thanks for your valuable input!


You are right, I'm really excited about this feature!


bt_avalonbay Frequent Visitor
Frequent Visitor

Re: Dax or M Language

I would add there is a concern we're running into given the Analyze in Excel feature in O365. Amounts/Values with a sigma next to them in your Fields list are not valid candidates for the Values section of the pivot table once you're in Excel. Only Measures with a calculator icon next to them in your Fields list are. So, what might be a valid candidate for aggregations in Power BI might not be available for the Analyze in Excel experience as you might imagine.