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 moreCategory: DAX
Sort 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 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 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 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 moreCONCATENATEX
CONCATENATEX is a DAX function introduced in Power Pivot for Excel 2016. It wont work in Excel 2013 or 2010[…]
Read moreGROUPING, BANDING, SEGMENTATION BASED ON RANGE OF VALUES
Grouping and Banding makes analysis easier and convenient Consider for example this table of 250 billionaires taken from www.forbes.com/billionaires/list Click[…]
Read moreEARLIER in DAX
EARLIER function is hard to understand in first go but it is even harder to explain. “EARLIER” is needed when[…]
Read more