Separate numbers, letters and special characters from string


How to find and separate the numbers, letters and special characters from string? Suppose you a column in table which contains a mix words which may includes numbers, letters, and special characters, or either numbers…

 247 total views,  4 views today

Read More...

Column Level Encryption Decryption using Symmetric Keys


SQL Server allows several options to protect sensitive data, and one of them is specifying a column level encryption. Using this option you can encrypt a column data also decrypt the data. SQL Server encrypts data…

 460 total views,  4 views today

Read More...

Create a calendar table in Power BI


In Power BI there are two DAX functions that you can use to generate a date series that is CALENDAR and CALENDARAUTO. The CALENDAR function requires two input parameters that is start date, and end…

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

 516 total views,  11 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…

 144 total views,  3 views today

Read More...

Merge in Power BI


Merge Queries in Power BI allows you to join two existing tables together based on matching values from one or multiple columns. Basically, it it is equivalent to JOINS which combines two queries into single…

 181 total views,  1 views today

Read More...

SQL QUOTENAME Function


SQL QUOTENAME function is a string function which returns a Unicode string with the delimiters added to make the input string a valid SQL Server delimited identifier. SYNTAX QUOTENAME ( character_string [ , quote_character ] )…

 163 total views,  2 views today

Read More...

SQL JSON_VALUE Function


JSON_VALUE is a JSON function which is used to extracts scalar value from JSON string. It returns a single text value of type nvarchar. It can not be used to extract JSON object or JSON…

 299 total views,  1 views today

Read More...

SQL JSON_QUERY Function


SQL JSON_QUERY is a JSON function which extracts an object or an array from a JSON string. JSON_QUERY function introduced in SQL Server 2016. You can not extract a scalar value using JSON_QUERY function. It…

 295 total views,  2 views today

Read More...

Row Level Security in SQL Server


Row-Level Security enables you to use group membership or execution context to control access to rows in a database table. Row level security feature introduced in SQL Server 2016. Once it is enabled, It applies…

 511 total views,  3 views today

Read More...

SQL JSON_MODIFY Function


The JSON_MODIFY is a JSON functions that allows you to update the value of a property in a JSON string. It introduced in SQL Server 2016. JSON_MODIFY function returns the updated JSON string. Using JSON_MODIFY…

 201 total views,  6 views today

Read More...

Small Multiple Line Chart Power BI Custom Visual


The Small Multiple Line Chart also known as Trellis bar chart is custom visual that is available in Power BI, it allows you to display a series of mini line charts that share the same…

 148 total views

Read More...

SQL Correlated Subquery


A correlated subquery is a subquery that uses the values of the outer query and it is evaluated for each row processed by the outer query. A correlated subquery always depends on outer query for…

 360 total views,  1 views today

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…

 230 total views,  7 views today

Read More...

RELATED Function DAX


RELATED function is a Power BI Relationship function in DAX which returns a related value from another table. The RELATED function requires that a relationship exists between the current table and the table with related…

 114 total views

Read More...

What If Parameter Power BI


What if Parameter gives you the ability to transform data dynamically. Using this you can easily evaluate you data behaviour under different conditions dynamically. Lets say for below given Sales data table, you want to…

 160 total views,  2 views today

Read More...

Change the Data Source dynamically in Power BI using Parameters


Changing the Data Source dynamically in Power Bi using Parameters Parameters in Power BI , basically is used for changing the argument values for particular transforms and data source functions and inputs in custom functions….

 540 total views,  7 views today

Read More...

Parameters in Power BI


Introduction to Parameters in Power BI Desktop Parameters in Power BI provides the flexibility to change the output of queries depending on their value dynamically. Parameters basically is used for changing the argument values for…

 262 total views,  2 views today

Read More...