Fixing Improper Dates in Power Query

Welcome to Excel Jet Consult blog post. In this tutorial, I will share with us how to solve the problem of improper date in Power Query. Let’s get started Quite often, I do get questions from people who have challenge of working with dataset that wasn’t correctly entered on Excel. Hence, I write this blog post to address the problem. […]

Continue reading

VLOOKUP in Excel and Power Query PBI

Welcome to Excel Jet Consult. In this tutorial, we want to look at how to perform vertical lookup in Excel and Power Query PBI. Let’s get started VLOOKUP in Excel VLOOKUP function looks for a value in the leftmost column of a table, and then returns a value in the same row from a column specified. VLOOKUP Syntax                             =VLOOKUP(lookup_value, table_array, […]

Continue reading

Understand One-To-Many Relationships in Power BI

Welcome to Excel Jet Consult blog post. In this tutorial, we want to take a cursory look at one-to-many relationships in Power BI. Creating relationships across imported multiple tables is important to perform accurate and reliable and easy-to-understand analysis for sound decision making. By default, Power BI is equipped to perform automatic relationship detection and creation between fact and dimension […]

Continue reading

Rolling Average In Power BI Power Query

Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to dynamically calculate Rolling Average in Power BI Power Query. Let’s get started. Statistically, Rolling Average or Running Average is a calculation that analyzes data points by creating a series of averages of different subsets of a comprehensive data set. In the caption below, we have […]

Continue reading