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
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
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
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
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
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
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…
596 total views, 4 views today
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
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
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
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
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
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
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
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
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
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
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
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
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