Aggregating Values in Multiple Columns using DAX
Suppose we have monthly sales for 10 Products as follows. Our objectives are to Compute the Maximum Monthly Sales for[…]
Read moreAuthor: Abu Hasan
Count only Working Days between 2 Dates
DATEDIFF function in DAX allows you to count the difference between 2 dates in terms of DAYS….(or even HOURS ,[…]
Read moreIncorrect Total for a MEASURE
When a measure is used in a Table or Matrix Visualization, it is common to get either no total or[…]
Read moreCompare 2 Lists
A common task for many Excel Users is to compare 2 or more lists and find out the missing values[…]
Read moreDistinct Count in Excel
The most Powerful tool (arguably) in Excel …Pivot Tables… do not allow the Distinct Count of a Field …..(at least[…]
Read morePulling Text Data from Many Side Table into One Side
Typically One Side Table is your LookUp Table. That is to say….Normally we lookup or pull a text value from[…]
Read moreRemoving Duplicate Rows in Power BI
Duplicate rows can be removed both using Query Editor and DAX We will use this simple data ITEMS Amount ENTITY[…]
Read moreAdding Calculated Row / Calculated Items Using Power Query
Following are the Revenue and Cost of Revenue of 3 Giant technology Companies for 3 years ENTITY ITEMS 2016 2017[…]
Read moreFinding the Column Name with Max or Min Value
Following is a list of price of 3 fruits in 5 countries. Our objective is to determine the Country with[…]
Read moreDirect & Indirect Count of Employees
Suppose following is the Line of Reporting in an Organization You are provided with the following table…Basically a table representation[…]
Read more