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…

 306 total views,  1 views today

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…

 1,004 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…

 857 total views,  8 views today

Read More...

ADDCOLUMNS function DAX


ADDCOLUMNS is a POWER BI Table Manipulation Functions in DAX which is used to add a calculated columns in table. Basically, ADDCOUMNS returns a table with new column specified in DAX expression. SYNTAX ADDCOLUMNS(<table_name>, <column_name>,…

 628 total views,  7 views today

Read More...