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…
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…
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…
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…
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…
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…
Xp_readerrorlog is a SQL Server extend stored procedure allows you read the contents of the SQL Server error log files. It allows you to read the SQL Server and SQL Server Agent error logs. SYNTAX…
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 ] )…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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….
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…