Welcome to Excel Jet Consult blog post. In this tutorial, we want to learn how to use the WHERE clause to filter between two dates. Let’s get started. In the caption below, we have the 2017 Data table fetched from our Transaction Records database We want to retrieve Product, Account Manager, Order Priority, Total Revenue from the Sales Data between […]
Continue readingTag Archives: SQL Server
Comprehensive SQL Server 2017 Installation
Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to fully download and install Microsoft SQL Server 2017. Let’s get started. DOWNLOAD SQL SERVER 2017 To download SQL Server 2017, type in download Microsoft SQL Server on google search. Click on the first search result In the caption below, click on the Developer edition Download […]
Continue reading
CROSSJOIN In SQL Server
Welcome to Excel Jet Consult blog post. In this tutorial, we want to replicate CROSSJOIN performed in Power BI Power Query and Power BI DAX. Let’s get started Kindly click on the link to be redirected to the blog post on how to CROSS JOIN using Power Query and Power BI DAX The first thing we must do is load […]
Continue reading
Fuzzy Matching In Power BI Power Query
Table.FuzzyNestedJoin M Function Fuzzy Matching in Power BI Power Query Welcome to Excel Jet Consult blog post. In this tutorial, we will learn about “approximate string comparison logic“ popularly known as “fuzzy matching” Fuzzy matching allows users to compare items in separate tables and join them if they are closely related In the caption below, we have two tables. We […]
Continue reading
Power BI: CALENDARAUTO & Two Ways To Create CALENDAR DAX Formula
Welcome to Excel Jet blog post. In this tutorial, we will learn what is CALENDERAUTO DAX function and CALLEDER DAX function. Let’s get started CALENDARAUTO returns a table with a single column named “Date” that contain a contiguous set of dates. The range of dates is calculated automatically based on the data in the model CALENDARAUTO Syntax =CALENDARAUTO() CALENDAR returns […]
Continue reading