» Power Query
» Power BI (RSS)
Sorry, but there are no more tags available to filter with.
Just a few days before my session about Power Query at TechEd 2014, Microsoft released a new update that enables the scheduled data refresh of a Power Pivot workbook containing Power Query transformations.
This is a very good news, because it enables the data refresh of a number of different data sources. Even if the number of providers supported ...
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 table in Excel:
You want to obtain a table containing the number of distinct products bought ...