Smileys in Dashboards
A Smile is an Inexpensive way to improve your look. By that analogy, Smileys can improve the look of your[…]
Read moreAuthor: Abu Hasan
Dealing 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 moreROW function—-PRACTICAL USES
“ROW” function returns a table with a single row containing values that result from the expressions given to each column.[…]
Read moreReplicating TEXTJOIN using VBA
Excel 2016 introduced the TEXTJOIN function which is a much improved version of CONCATENATE function. I always found CONCATENATE quite[…]
Read moreRange Bar Chart
A Range Bar Chart looks like this and is very useful for displaying change between 2 points in time I[…]
Read moreValue or X-Axis of charts should not be truncated for Column/Bar and similar charts
Microsoft Excel automatically truncates the VALUE Axis or X-Axis of charts when the variance between the lowest and highest values[…]
Read moreUse INDIRECT to Pull Data from Different Worksheets/ Named Ranges
INDIRECT is a Powerful function in Excel. In this post I am going to show you how INDIRECT can be[…]
Read moreFILTER CONNECTS UNRELATED TABLES
One important feature of FILTER function in DAX is that it can establish a relationship between two tables when no[…]
Read more