Welcome to Excel Jet Consult blog post. In this tutorial, we want to learn how to delete records that equal to Null in multiple columns. Let’s get started In the caption below, we can see that we have NULL values in Order Date and Ship Date columns To delete the transaction records that equals to NULL Execute the queries: delete […]

Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to use Top N and Bottom N features in Power BI Filtering. Let’s get started In the caption below, we have two reports which are Total Revenue by Product Names respectively. Top 5 Total Revenue By Product Names We want to filter the two reports to […]

Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to use the Sort by column feature in Power BI. Let’s get started The Sort By Column is located in the Sort group of the Modelling tab. In the below, we created a quick report using Table visualization. The report is based on Total Revenue by […]

Welcome to Excel Jet Consult blog post. In this short video tutorial, we will learn how to import, retrieve and combine multiple CSV File in Power BI. Enjoy the video  

Welcome to Excel Jet Consult blog post. In this tutorial, we want to learn how to use the rarely known tool in Excel which replaces the Merge & Center. Over time, I have seen many Excel users deploying the Merge & Center tool to merge and center headings in couple of cells. This is not the best practice because it […]

Welcome to Excel Jet Consult blog post. In this tutorial, we want to learn how to use Sum of Years Digit Depreciation function known as SYD Function. Let’s get started Sum of Years Digits method is an accelerated depreciation that assumes that the productivity of an asset decreases with a period. Sum of Years Digits charges a higher depreciation expense […]

Welcome to Excel Jet Consult blog post. In this tutorial, we want to learn how to use Straight Line Depreciation function known as SLN Function. Let’s get started Straight line basis is a method of calculating depreciation and amortization. It represents the simplest method to estimate the loss of value of an asset over time. To calculate loss of value […]

Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to modify Map chart to reference Pivot Table and filter using Slicer. Let’s get started Traditionally, it is impossible to use Map, Treemap, Waterfall, Sunburst charts inside Pivot Table. However, to use the above-mentioned chart inside Pivot Table, it is required to know how to modify […]

Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to use the SUMX Dax Function in Excel Data Model. SUMX Function returns the sum of expression evaluated for each row in a table SUMX Syntax                                     =SUMX(<table>, <expression>) Table – the specific table containing the rows for which the expression will be evaluated Expression – the […]

Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to apply Logical Condition, Color Index and Symbols for custom formatting. Let’s get started In the caption below, we have sales data generated by each of the Account Managers. We can see that some of the Account Managers generated Sales running to millions while some are […]