Articles (26)
DAX Language - RANKX Function
A.Baddane | May 05, 21
The RANKX function returns a single integer value that represents the rank of an expression in the list of values for ea...
Read More →
DAX Language - AND and OR Functions
A.Baddane | April 10, 21
AND/OR functions check whether all arguments are TRUE or one of the arguments is TRUE, and return a single boolean value...
Read More →
DAX Language - Variables in DAX
A.Baddane | April 10, 21
Use Var keyword to store the result of an expression as a named variable and passed it as an argument to other measure e...
Read More →
DAX Language - COUNT and COUNTX
A.Baddane | April 09, 21
The COUNT and COUNTX functions count the number of non blank cells in a column and a non-blank value when evaluating an ...
Read More →
DAX Language - SAMEPERIODLASTYEAR
A.Baddane | April 09, 21
The SAMEPERIODLASTYEAR DAX function returns a table that contains a column of dates shifted one year back in time from t...
Read More →
DAX Language - CALCULATE Function
A.Baddane | April 08, 21
The CALCULATE DAX function changes the context in which the data is filtered. If there is a filter applied to a column u...
Read More →
DAX Language - ALL Function
A.Baddane | April 08, 21
The ALL DAX FUNCTION is used for clearing filters and creating calculations on all the rows in a table. An example of us...
Read More →
DAX Language - SWITCH Function
A.Baddane | April 07, 21
The SWITCH function evaluates an expression against a list of values and returns one of multiple possible result expr...
Read More →