Welcome to Excel Jet Consult. In this tutorial, we will learn how to use the following DAX aggregator functions – COUNT, SUM, AVERAGE, MAX and MIN with ROLLUP Nested Inside SUMMARIZE DAX Function. Let’s get started. COUNT Function counts all the number in a column COUNT Syntax                                                   =COUNT(ColumnName) SUM Function adds all the numbers in a column SUM Syntax                                                        =SUM(ColumnName) […]

Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to use SUMX and RELATED Dax functions to iterate and return related value in another table. Let’s get started SUMX function returns the sum of an expression evaluated for each row in a table SUMX Syntax                                     =SUMX(table, expression) RELATED function returns a related value from another […]

Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to extract data that I stored in PDF. Let’s get started In the caption below, we have the Transaction data stored in PDF and we would like to extract the data in Power BI for further analysis To extract: In the External Data group of the […]

Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to deploy the Table.Sort Table.Sort Power Query M Function to sort multiple columns. Let’s get started Table.Sort sorts columnar data in table using the list of one or more column names and optional comparison criteria in the form of {{col1, comparisonCriteria),{col2}) Table.Sort Syntax                             =Table.Sort(table, comparisonCriteria)   […]

Welcome to Excel Jet Consult blog post. In this tutorial, we want to learn how to use Sum with Order By Clause on multiple columns in ascending and descending order. Let’s get started In the caption below, we want to retrieve Region, Country and Item Type. Furthermore, we want to apply $ currency formatting to the expected Total Revenue and […]

Welcome to Excel Jet Consult blog post. In this tutorial, we want to learn how to calculate Total Revenue and Total Cost on a row-by-row context. Let’s get started In the caption below, we want to calculate Total Revenue and Total Cost Execute the query: select Region, Country, [Item Type], [Sales Channel], [Order Priority], [Order Date], [Order ID], [Ship Date], […]