Reading Jen Stirrup’s great article about the learning path for SQL Server 2016 and R I ended up learning my first R pieces from this wonderful post that she has referenced. (…) Read more
Posts in Category ‘Power BI’
Tip for Parameter Tables in Power Query and Power BI
Parameter tables in Excel are normally set up like this: In order to retrieve the currency for example, you could write this: = Parameters[Value]{2} This returns the content of the “Value”-column of (…) Read more
How to compare everything with everything using Power BI or Power Query
A question in Mr. Excel-Forum about how to design your data model if you want to compare values from 10 different (fact-) tables with each other got me curious: (…) Read more