Welcome to Excel Jet Consult blog post. In this tutorial, we are going to learn how to use single cell formula to create fiscal period calendar table in Excel worksheet. Let’s get started Video Sample Data From the screenshot below, we’ve got date that spanned from 01/01/2020 to 31/12/2013 in column A. Single Cell Formula to Create the Calendar Table […]
Continue readingConsistent Performers: Identifying Products Sold in Every Quarter of 2017
Welcome to Excel Jet Consult blog post. In this blog post, we’ll explore how to write SQL to identify products that were consistently sold in every quarter of the year 2017. Let’s get started. With a simple SELECT * FROM factSalesTable, we fetched all the records in the table as seen below To identify the best selling products in every […]
Continue readingAnalyze PowerBI Dataset in Excel for the Web
Welcome to Excel Jet Consult blog post. In this video, we are going to learn how to analyze PowerBI Dataset in Excel for the Web. Let’s get started Video The screenshot below shows a dynamic report created in the PowerBI Desktop and published to the PowerBI Service. We want to access the underlying dataset that contains the fact table, dimension […]
Continue readingTotal Sales by Quarter Grouped By Year
Welcome to Excel Jet Consult blog post. In this SQL Server video tutorial, we are going to learn how to calculate total sales by quarters grouped by Year. Let’s get started. Dataset The screenshot contains a simple select all statement to fetch all the records in the Monthly Sales table Total Sales by Quarters Grouped By Year To calculate Total […]
Continue readingRefreshing IntelliSense Cache in SSMS to Keeping Your SQL Coding Experience Sharp
Hello and welcome to Excel Jet Consult blog post. In this blog post, we are going to look at how to handle cache in SSMS to keep your SQL Query sharp. Le’ts get started. IntelliSense is a handy feature in SQL Server Management Studio (SSMS) that helps users to write SQL code more efficiently by providing auto-completion suggestions and syntax […]
Continue readingForcing Additive Measures in Power BI
Introduction Welcome to Excel Jet Consult blog post. In this blog, I will walk us through the concept of forcing additive measure in Power BI. Let’s get started Understanding Additive vs. Non-Additive Measures In Power BI, measures can be categorized as additive or non-additive based on how they aggregate when multiple data points are combined. Additive measures are those that […]
Continue readingCreate Calendar Table and Calculate Total Sales by Fiscal Period in Power Pivot Data Model
Welcome to Excel Jet Consult blog post. In this Excel tutorial, we will learn how to create calendar table and calculate total sales by fiscal period in Power Pivot Data Model. Let’s get started Sample Data and Loading to the Data Model In the screenshot below, we’ve got a sales dataset that is officially stored as an Excel Table using […]
Continue readingFinding the Products with a Price Above the Yearly Average Price in SQL Server
Welcome to Excel Jet Consult blog post. In this tutorial, we are going to consider how to write sql query to return the products with a price above the yearly average price. Let’s dive in. With a simple SELECT * FROM factSalesTable, we fetched all the records in the table as seen below To find all products with a price […]
Continue readingNew Automatic Duplicate Values Removal in List Data Validation in Excel
Welcome to Excel Jet Consult blog post. In this Excel tutorial, we will see how to use the new automatic duplicate values removal in List Data Validation in Excel. Note, new feature is currently available to Beta Channel users of M365 as at the time of writing this blog post. Let’s get started Tutorial Video In the previous blog post […]
Continue readingUse Images in PivotTable Report in Excel [New Feature]
Welcome to Excel Jet Consult blog post. In this Excel tutorial, we will see how to use images in PivotTable Report which is a new feature currently available to Beta Channel users of M365 as at the time of writing this blog post. Let’s get started Sample Data and Loading to the Data Model In the screenshot below, we’ve got […]
Continue reading