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…

 324 total views,  10 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...

Calculated Columns


Microsoft Power BI allows you to create a calculated columns means you can add a new column to an existing table in your data model, and instead of querying and loading values for new column…

 403 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...

Sort By Months Name in Power BI


When you perform sorting on months name, you will see that months name are sorted alphabetically as text, strings are sorted alphabetically by default. While you expect to see months name to be sorted chronologically….

 568 total views,  7 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...