SQL NULLIF


SQL NULLIF expression compares two expression and returns a null value if the two specified expressions are equal, else it returns the first expression. NULLIF  expression is equivalent to a searched CASE expression in which…

 291 total views,  1 views today

Read More...

SET STATISTICS IO


SQL STATISTICS IO is a set statement , when it is enabled it causes SQL Server to display information about the amount of disk activity generated by T- SQL statement. SYTANX SET STATISTICS IO {…

 252 total views

Read More...

SQL IS NULL


The IS NULL is used in SQL to find a NULL value. It returns TRUE if a NULL value is found, otherwise it returns FALSE. SYNTAX SELECT col1, col2, .. FROM Table WHERE Expression IS…

 198 total views,  1 views today

Read More...

SQL IS NOT NULL


The IS NOT NULL is used in SQL to find a non-NULL value. It returns TRUE if a non-NULL value is found, otherwise it returns FALSE. SYNTAX SELECT col1, col2, .. FROM Table WHERE Expression…

 240 total views,  1 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>)…

 416 total views

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…

 519 total views,  3 views today

Read More...

Pivot Columns in Power BI


Pivot column is a feature available in Power Query which allows you turn rows to columns. Basically, Power Query groups each unique values and performs an aggregation that you specify such as sum, max, min,…

 813 total views,  1 views today

Read More...

How to Update from Select Statement in SQL


SQL Server update statement is used used to modify an existing records in a table, you can also update records in table based on some specific conditions. Following is the basic syntax of update statement….

 783 total views

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…

 158 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…

 270 total views,  5 views today

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…

 251 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…

 518 total views,  2 views today

Read More...

Insert multi language data in table


Sometimes, you need to store multi language or multilingual data in any table column. Inserting a multilingual data into column without following some basics rules, you see that when you select data from table, it…

 498 total views,  3 views today

Read More...

SQL Random Number


SQL RAND function is a mathematical function which returns a pseudo-random float value from 0 through 1, exclusive or a random value within any range. It can also take an optional seed parameter which is…

 812 total views,  1 views today

Read More...

How to insert the result of a stored procedure into table


Sometimes, you want to store the result of a stored procedure into table or temp table instead of returning the output. Storing output of stored procedure into table enables more option for you, such as…

 1,389 total views,  9 views today

Read More...

SQL Delete TOP


SQL delete statement is used to delete records from table based on specific conditions which are specified in where clause. Delete statement can also be used as Delete TOP, which also allows you to use…

 637 total views

Read More...

Delete Horizontal White Space in SQL Serve


When you are required to import data received from different different file format such as .txt, .csv., or excel files, sometimes you see a white spaces along with the data, which may create a problem…

 271 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….

 1,245 total views,  3 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…

 582 total views,  7 views today

Read More...

Date and Time Conversions in SQL Server


Sometimes you need to format a date in specific format such as format a date time string YYYY-MM-DD hh:mm:ss. mmm to date MM:DD:YY. SQL Server provides you a various options that you can use to…

 518 total views,  1 views today

Read More...