Introduction Welcome to Excel Jet Consult blog post. In this tutorial, we will learn some unusual method to create any chart. Let’s get started Sample Data In the caption below, we have simple data showing Account Managers and sales for each quarters. Create Empty Column Chart To create and empty column chart Select any cell outside the data In the Charts group […]
Continue reading
Dynamic Chart Title
Introduction Welcome to Excel Jet Consult blog post. In this tutorial, we are going to learn how to make chart title dynamic. Let’s get started Sample Data In the caption below, we have a sample data Create Chart For this example, we will create a clustered column chart. Dynamic Chart Titles works on all charts. In the Charts group of the Insert tab, […]
Continue reading
Alternative To Power BI COALESCE DAX Function In Excel Data Model
Welcome to Excel Jet Consut blog post. In my previous post on COALESCE DAX Function in Power BI, I show us how to use COALESCE DAX Function which returns scalar value coming from one of the expressions or BLANK if all expressions evaluate to BLANK. In this tutorial, we are going to learn how to fill blank rows with value […]
Continue reading
Role of Comma and Semicolon in Curley Braces{}
Introduction Welcome to Excel Jet Consult blog post. In this video tutorial, we learn about when to use comma and semicolon to achieve the same result in different way. Sample Data In the caption below, we have sample data that has Account Manager and Total Sales. Note, the data is formatted in Excel Tables Top 5: Spill To Cells Below […]
Continue reading
KEEPFILTERS DAX Function
Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to use the KEEPFILTERS DAX Function to create Single and Multiple Columns Filters. Let’s get started. Definition of Function and Syntax KEEPFILRERS modifies how filters are applied while evaluating a CALCULATE or CALCULATETABLE function. The KEEPFILTERS function allows you to modify this behavior. When you use […]
Continue reading
FILTER As Alternative To VLOOKUP, INDEX MATCH & XLOOKUP Functions
Introduction Welcome to Excel Jet Consult blog post. In this blog post, we will learn how to use FILTER Dynamic Array Function to perform the same operation that lookup family functions such as VLOOKUP, INDEX MATCH and XLOOKUP will perform. Let’s get started Definition of FILTER Function & Syntax The FILTER Function filters a range or an array Syntax […]
Continue reading
COALESCE DAX Function
Welcome to Excel Jet Consult blog post. In this video tutorial, I demonstrate how to use the new COALESCE DAX function made available in March 2020 Power BI updates.
Continue reading
Create PivotTable From Multiple Consolidated Ranges
Welcome to Excel Jet Consult blog post. In this tutorial, we will learn the old way of creating PivotTable from multiple consolidated ranges using the Office 2003 PivotTable and PivotChart wizard. Let us get started In the captions below, we have January: March Report of sales data showing Account Manager and the values for each Product which are Seafood, Beverages, […]
Continue reading
Summing Every Third Rows Across Multiple Columns
Introduction Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to sum every third rows across multiple columns. Let’s get started Sample Data In the caption below, we have our sample data we will use to achieve the technical calculation. Note, our data is formatted in Excel Table and we provided Sales_Data as the Table Name Calculation […]
Continue reading
Modelling Using New LET Function
Welcome to Excel Jet Consult blog post. In this tutorial, we will learn about how to use the newly released LET Function for modelling. Let’s get started Definition of Function & Syntax The LET function assigns names to calculation results. This allows storing intermediate calculations, values, or defining names inside a formula. These names only apply within the scope of the LET […]
Continue reading