Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to use the DAX iterator function called MAXX. Let’s get started MAXX Function returns the largest numeric value or the largest string that result from evaluating an expression for each row in a table MAXX Syntax: =MAXX(table, expression) MINX Function returns the smallest numeric value […]
Continue reading
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
How To Horizontally Sort Data In Excel
Welcome to Excel Jet Consult. In this tutorial, we will learn how to achieve horizontal sorting of data in Excel. Let’s get started In the caption below, we want to sort the Account Manager in Row 3 from A to Z To sort the data horizontally, I selected the data from B3:O6 Execute: ALT + ASS to open […]
Continue reading
Delete Blank Rows In Power BI and Excel
Welcome to Excel Jet Consult. In this tutorial, we will learn how to identify and delete blank rows in Power BI and Excel. Let’s get started Having blanks rows in files prevent us from taking full advantage of the myriads of functionalities in Power BI and Excel. So, whenever, we have blanks rows in our data, it is pertinent to […]
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
Power BI: YEARFRAC DAX Function
Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to use the YEARFRAC DAX Function. Let’s get started YEARFRAC DAX function calculates and returns the fraction of the year represented by the number of whole days between two dates. YEARFRAC DAX function uses datetime format in lieu of the serial numbers that is used in […]
Continue reading
Power BI Power Query: Extract Data Using Column From Examples
Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to extracting data using Column by example feature in Power BI Power Query otherwise known as Flash Fill in Excel. However, before we see how to do this in Power BI, we are going to use the same data and extract data in Excel using flash […]
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
How To Perform CROSSJOIN In Power Query & Power BI
Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to perform CROSSJOIN in Power Query and Power BI DAX. Let’s get started CROSSJOIN returns a table that contains the Cartesian product of rows from all tables in the arguments. The columns in the new table are all the columns in all the argument tables CROSSJOIN […]
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