LASTNONBLANK function DAX


LASTNONBLANK function is a Power BI time intelligence function in DAX which returns the last value in the column filtered by the current context for which the expression has a non blank value. It returns…

 297 total views,  5 views today

Read More...

TRUNC function DAX


TRUNC function is a Power BI math and trig function in DAX, which truncates a number to an integer by removing the decimal, or fractional part of the number. TRUNC function does not round the…

 171 total views,  6 views today

Read More...

LOWER function DAX


LOWER function is a Power BI text functions which converts a text string to all lowercase letters. SYNTAX LOWER (<text>) text is the text you want converted to lowercase, or a reference to a column…

 70 total views,  1 views today

Read More...

UPPER Function DAX


UPPPER function is a Power BI text functions which converts a text string to all uppercase letters. SYNTAX UPPER (<text>) text is the text you want converted to uppercase, or a reference to a column…

 64 total views,  2 views today

Read More...

MID Function DAX


MID function is a Power BI text functions in DAX, it returns a string of characters from the middle of a text string based on a given starting position and length. SYNTAX MID(<text>, <start_num>, <num_chars>)…

 225 total views,  3 views today

Read More...

FORMAT Function DAX


FORMAT function is a Power BI text function in DAX, which converts a value to text according to the specified format. Syntax FORMAT(<value>, <format_string>) value is a value or expression that evaluates to a single…

 340 total views,  5 views today

Read More...

REMOVEFILTERS Function DAX


REMOVEFILTER function is a Power BI filter function in DAX, It removes filters from the specified tables or columns. It can only be used to remove filters but not to return a table. SYNTAX REMOVEFILTERS([<table>…

 278 total views

Read More...

TOTALYTD Function DAX


TOTALYTD is a Power BI time intelligence function in DAX, which evaluates the year-to-date value of the expression¬†in the current context. DAX SYNTAX TOTALYTD(<expression>,<dates>[,<filter>][,<year_end_date>]) expression An expression that returns a scalar value. dates Is a…

 325 total views,  11 views today

Read More...

REPLACE Function DAX


REPLACE function is a Power BI text function in DAX, which replaces part of a text string based on the number of characters you specify, with a different text string. SYNTAX REPLACE(<old_text>, <start_num>, <num_chars>, <new_text>)…

 261 total views,  1 views today

Read More...

PATHREVERSE function DAX


PATHREVERSE function is a Power BI Parent and Child function in DAX which returns the item at the specified position from a string resulting from evaluation of a PATH function. Positions are counted backwards from…

 110 total views

Read More...

PATHITEM Function DAX


PATHITEM function is a Power BI parent and child function in DAX which returns the item at the specified position from a string resulting from evaluation of a PATH function. Positions are counted from left…

 89 total views

Read More...

PATHLENGTH Function DAX


PATHLENGTH function is a Power BI parent and child function in DAX, which returns the number of parents to the specified item in a given PATH result, including the specified item. SYNTAX PATHLENGTH(<path>) Path Is…

 151 total views

Read More...

PATH Function DAX


Path function is a Power BI Parent and Child Functions in DAX, which returns a delimited text string with the identifiers of all the parents of the current identifier, starting with the oldest and continuing…

 365 total views,  1 views today

Read More...

EOMONTH Function DAX


EOMONTH function is a Power BI Date and time function in DAX which returns the date in datetime format of the last day of the month, before or after a specified number of months. It…

 267 total views,  3 views today

Read More...

REPT Function DAX


REPT functions is a Power BI text function in DAX which repeats text a given number of times. SYNTAX REPT(<text>, <num_times>) text is the text that you want to repeat. num_times is a number which…

 88 total views

Read More...

SAMEPERIODLASTYEAR Function DAX


SAMEPERIODLASTYEAR is a Power BI time intelligence function in DAX which returns a table that contains a column of dates in the current selection of previous year. It is specific to a year interval and…

 737 total views,  5 views today

Read More...

TOPN Function DAX


TOPN function is a Power BI table manipulation function in DAX which returns the top n records from table. If you specify the number 0 to TOPN function or any less number then TOPN returns…

 514 total views,  9 views today

Read More...

FILTER Function DAX


Filter is a Power BI filter functions in DAX which returns a table that represents a subset of another table or expression. It filter the table under current filter context. It returns the table that…

 141 total views

Read More...

USERRELATIONSHIP Function DAX


USERRELATIONSHIP function is a Power BI Relationship function in DAX which Specifies the relationship to be used in a specific calculation as the one that exists between two columns. To use USERRELATIONSHIP function there must…

 290 total views,  1 views today

Read More...

GENERATESERIES Function DAX


GENERATESERIES function is a Power BI Table Manipulation function in DAX which returns a table with one column which contains sequential values from start to end. SYNTAX GENERATESERIES(<start_value>, <end_value>[, <increment_value>]) start_value is the initial value…

 229 total views,  6 views today

Read More...