Recursive Functions in Power BI / Power Query
Have you ever heard about Recursion or Recursive functions? They are present…
The Power User
Technology and data preparation articles written by Miguel Escobar.
Logical Operators and Nested IFs in Power BI / Power Query
In the previous post I showed you guys how to create a conditional column in Power BI / Power Query using the UI and then just using the Power Query Formula language. In this post we’ll go over the available conditional operators and how to do Nested IFs in Power BI / Power Query.
Parameter Tables in Power BI / Power Query
One of the most interesting and most unique scenarios is Parameter Tables in Power Query / Power BI. The way to make a dynamic Power Query solution is to make sure that it can be easily customizable
Extracting Header and Footer Values from Documents, Files using Power BI + Using PDF Connector
Have you ever had a similar situation where a REALLY important value…
RETRY recursive function in Power BI & Power Query
Recursive functions are a topic that I rarely come across. To give…
The Navigation Step in Power Query and Power BI - Navigating to rows, columns and cells
What is a “Navigation” step in Power Query? When using Power Query,…
Calculate Days between dates using Power Query / Power BI / Dataflow
Have you ever wanted to find out how many days you have…
Recurring dates with offset in Power Query
Imagine this scenario, you are a Doctor who has multiple appointments with…