Finding 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 moreAuthor: Abu Hasan
Direct & 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 moreCell Colors Manager
This Free Excel Add-In captures all Cell Colors in the Active WorkSheet and then allows you to replace them with[…]
Read moreSort the Total Row in a TABLE
Totals are shown either at the beginning or the end of the VISUAL. However sometimes it is desirable to SORT[…]
Read moreIndex Column by Category
Power Query or the Query Editor allows you to insert an INDEX COLUMN which is very useful in many ways[…]
Read moreHorizontal Bullet Charts Maker
A bullet chart provides a rich display of data in a small space. It was developed by Stephen Few, the[…]
Read moreSmileys in Dashboards
A Smile is an Inexpensive way to improve your look. By that analogy, Smileys can improve the look of your[…]
Read moreDealing with Duplicates “A Table of Multiple Values was supplied” using DAX
“A table of multiple values was supplied where a single value was expected” is a common error in DAX especially[…]
Read moreUsing FirstNonBlank / LastNonBlank in DAX
As per Microsoft’s Developer Network library, FirstNonBlank /LastNonBlank return the first/last value respectively in the column, column, filtered by the[…]
Read moreAssigning Macros to Drop Down Lists in Excel
Assigning macros to Form Controls is easy and to Active X controls is easier because they expose themselves to a[…]
Read more