Power BI Power Query New Features: Column Quality, Distribution & Profile

Welcome to Excel Jet Consult. In this tutorial, we want to learn about the new feature in Power BI Power Query Editor COLUMN QUALITY Shows the quality of data preview. Light blue colour indicate that all preview data is valid. Red colour indicate that there is error in the data while the black colour indicate that there are empty cells […]

Continue reading

Using SUMPRODUCT Function Devoid of Cell References

Welcome to Excel Jet Consult blog post. In this short tutorial, we want to learn how to use the elegant SUMPRODUCT function without cell reference. SUMPRODUCT returns the sum of the products of corresponding ranges or arrays SUMPRODUCT Syntax                    =SUMPRODUCT(array1, [array2], [array3], …) In cell J5, we want to calculate the Total Revenue Account Manager named Connor Rulibeth, Seafood Product1, […]

Continue reading

SUMIFS Function With 4 INDIRECT Function To Deliver Dynamic Total Sales

Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to use SUMIFS and INDIRECT Functions to perform a dynamic Total Sales. SUMIFS is a native Statistical function that adds the cells specified by a given criteria SUMIFS Syntax                  =SUMIFS(sum_range, criteria_range1, criteria1, ..) INDIRECT is a native elegant Lookup function. It delivers the reference specified by […]

Continue reading

Excel VBA: MAXIFS Function With Multiple Criteria

Welcome to Excel Jet Consult. In this tutorial, we will learn how to use the new MAXIFS Function with multiple criteria in VBA. Let’s get started MAXIFS Funtion returns the maximum value among cells specified by a given criteria or conditions MAXIFS Syntax                  =MAXIFS(max_range, criteria_range1, criteria1, …) Argument Max_Range – the range that contains the numeric values to evaluate Criteria_range1 […]

Continue reading

Discover & Display All The 919 Power BI Power Query Mash-up Functions

Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to discover and display all the Power BI Power Query Mash-up Functions and their definitions and usage Open a blank Power Bi Desktop In the External Data group of the Home tab, click on Get Data drop-down Select Blank Query In the formula bar, execute the […]

Continue reading