Office 356 Stocks Data Types: Retrieve Stocks Information

Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to use the Stocks Data Type to retrieve Stocks Information for different companies. Let’s get started. The Stocks Data Type is available in Office 365 version and it is in the Data tab In the caption below, we want to retrieve the following: Industry, Market Capitalization, […]

Continue reading

Summing Values BETWEEN Two Dates In Power BI and Excel

Welcome to Excel Jet Consult blog post. In this tutorial, we are going to learn how to sum values using DAX DATESBETWEEN function in Power BI as well as using SUMIFS in Excel. Let’s get started   DATESBETWEEN returns a table that contains a column of dates that begins with the start_date and continues to the end_date DATESBETWEEN Syntax                                 =DATESBETWEEN(dates, […]

Continue reading

Advanced Conditional Formatting: Format Dates Between

Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how highlight date between two dates using conditional formatting In the caption below, we want to highlight the transaction generated between 14/01/2014 and 30/01/2014 Select all the date value from cell B4 downward using CTRL + SHIFT + Down Arrow Execute CTRL + Backspace to move up […]

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