Browse by Tags

• Excel 2013
• Power BI
• PowerPivot

• Calculate Distinct Count in a Group By operation in Power Query #powerquery #powerbi

  The current version of Power Query does not have a user interface to create a Distinct Count calculation in a Group By operation. However, you can do this in “M” with a simple edit of the code generated by the Power Query window. Consider the following Read More... Posted Monday, March 31, 2014 7:23 PM by Marco Russo (SQLBI) | 2 Comments Filed under: Power Query, Power BI

• Power Query now imports relationships #powerquery #powerpivot

  The December release of Power Query preview (version 2.9.3502.261) introduced an interesting feature: when you import multiple tables in the data model, relationships existing between tables in the data source are automatically detected and added to the Read More... Posted Tuesday, December 17, 2013 3:42 PM by Marco Russo (SQLBI) | 6 Comments Filed under: PowerPivot, Excel 2013, Power Query