Handling Different Time Zones in Power BI / Power Query
What time is it right now for you? We might share the…
Power Query (10)
Fill dates between dates with Power BI / Power Query
One of my most popular posts is one about recurring dates with…
Recursive Functions in Power BI / Power Query
Have you ever heard about Recursion or Recursive functions? They are present…
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,…