Today I’m going to share my custom NETWORKDAYS function for Power Query with you that uses the same syntax than its Excel-equivalent. NETWORKDAYS function This function’s first 3 parameters work (…) Read more
All Posts by Imke F
Tidy up Power BI models with the Power BI Cleaner tool
Edit: I am retiring support for this tool for now, as you can find an alternative here: Measure Killer | Brunner BI. Please feel free to use this tool as (…) Read more
Advanced transformations on multiple columns at once in Power BI and Power Query
You can apply simple transformations to multiple columns at once in Power Query using the UI only. In this article I show how you can apply advanced transformations on multiple (…) Read more
Dynamically create types from text with Type.FromText in Power Query and Power BI
In this article I’ll show you how to create types from text in Power Query, enabling you to dynamically change types via functions for example. It’ll come out as a (…) Read more
DAX evaluation context indicator with syntax highlighting
This is a post about a feature request, that definitely would make my life easier (and I guess others’ too): Evaluation context and its transition is one of the hardest (…) Read more
Tips and Tricks for R scripts in the query editor in Power BI
Especially if you are new to R, there are some things one needs to know to successfully run R-scripts in the query editor of Power BI. I will share them (…) Read more