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
Power BI (14)
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…