Some time ago I wrote a blogpost on how to create a function library in Power BI or Power Query (http://www.thebiccountant.com/2017/08/27/how-to-create-and-use-r-function-library-in-power-bi/). There I also presented a way to pull that (…) Read more
All Posts by Admin
Permutations table in Power BI or Power Query in Excel
Today my husband came with a special task to me: He had to re-wire an old instrument on board of our sailing boat and “lost” the original matching instructions. There (…) Read more
Stretching and Compressing Time Series with Power Query and Power BI
The good folks from SumProduct have published a challenge for Excel that I find worth doing in Power Query instead: The Challenge Stretching or compressing a forecast so that the proportion of (…) Read more
RegEx in Power BI and Power Query in Excel with Java Script
From time to time Huang Caiguang sends me some geeky M-code that turns out to be very useful (like this for example). Today it’s utilizing java script code for RegEx (…) Read more
Migrate a Power Query or Power BI file to a local SSAS instance
Edit: This feature has been deprecated since 1st March 2019 unfortunately: https://azure.microsoft.com/en-us/updates/azure-analysis-services-web-designer-to-be-discontinued/ – Microsoft is working on replacement of the functionality to move pbix-files to SSAS-instances, but no solution yet. In (…) Read more
GuestPost: Newbie to Newbie Learning M-Language as your first Programming Language
Foreword from Imke: “Happy to publish my 2nd guest post here: I met Rafael Knuth in the Technet-forum where it was a joy to see how quickly he was set (…) Read more