Articles

Articles written by A-Badde (16menu_book)


DAX Language - SWITCH Function

A-Badde | April 07, 20

The SWITCH function evaluates an expression against a list of values and returns one of multiple possible result expr...

Read More →

DAX Language - IF Function

A-Badde | April 07, 20

The IF function checks if a condition provided as the first argument is met. Returns one value if the condition is TR...

Read More →

RELATED and RELATEDTABLE Functions

A-Badde | April 06, 20

RELATED and RELATEDTABLE return a related value from another table or evaluate a table expression in a context modifi...

Read More →

Transpose Data in Power BI

A-Badde | April 06, 20

The Transpose feature in Power BI switchs data from columns to rows, or vice versa. If you have a query with data in ...

Read More →

DAX Language – SUM and SUMX Functions

A-Badde | April 05, 20

The SUM and SUMX functions are used to calculate the sum of a column or an expression. The function takes as its...

Read More →

DAX Language - FILTER Function

A-Badde | April 04, 20

The Filter function is used to return a subset table of an expression or a table.The FILTER function is generall...

Read More →

The DAX language

A-Badde | April 03, 20

The Data Analysis Expressions (DAX) language is used to build formulas and expressions in several Microsoft Products....

Read More →

What is Power Query ?

A-Badde | April 02, 20

Power Query is the Microsoft Data Connectivity and Data Preparation technology that enables end users to seamlessly i...

Read More →

About author
A-Badde

Microsoft BI Consultant

Categories
Recent Posts
DAX Language - CONTAINS Function
A-Badde | May 09, 20

The CONTAINS function returns a boolean value, TRUE if each ...Read More


DAX Language - RANKX Function
A-Badde | May 05, 20

The RANKX function returns a single integer value that repre...Read More


DAX Language - AND and OR Functions
A-Badde | April 10, 20

AND/OR functions check whether all arguments are TRUE or one...Read More


DAX Language - Variables in DAX
A-Badde | April 10, 20

Use Var keyword to store the result of an expression as a na...Read More