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…

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

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

 383 total views,  2 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…

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

 733 total views,  5 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…

 498 total views,  1 views today

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…

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

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

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

 342 total views,  2 views today

Read More...

Get Row Counts for all tables in SQL Server


Sometime you are required to validate the row counts for each tables in database. So getting a row counts for each tables either through using a loop on each table or go and get row…

 708 total views,  13 views today

Read More...

Implementing a Table Heat Map in Power BI


A Heat map is used to visualize the density of data using colors where highest data value is displayed through dark heated color, and same color turns in light color for lowest values. In Power…

 365 total views,  1 views today

Read More...

Dynamic Data Masking in SQL Server


Dynamic data masking also known as DDM is a security feature in SQL Server which helps you to prevent the access of unauthorize users to sensitive data in the database. It was introduced in SQL…

 557 total views,  33 views today

Read More...

REPT Function DAX


REPT functions is a Power BI text function in DAX which repeats text a given number of times. SYNTAX REPT(<text>, <num_times>) text is the text that you want to repeat. num_times is a number which…

 88 total views

Read More...

View Collation Information in SQL Server


Collations in SQL Server provide sorting rules, case, and accent sensitivity properties for your data. You can easily find SQL collation at the server, database and column level using SQL Server System Catalog views, or…

 310 total views,  1 views today

Read More...

Import text using examples feature Power BI


Power BI August 2020 update has released a new feature Import text using examples, which allows you to import text/csv file which allows you to specify sample output values for the data you would like…

 269 total views,  1 views today

Read More...

Introduction to Workspace in Power BI, Assign Roles and Permission


In Power BI service a workspaces are places to collaborate with colleagues to create collections of dashboards, reports, datasets, and paginated reports. You can add users who can access, edit, and read the content in…

 628 total views,  3 views today

Read More...

SQL SELECT TOP


SQL SELECT TOP statement is used to retrieve records from tables and limit the number of rows or percentage of rows returned based on a specified value. It is also known as TOP Clause or…

 240 total views,  6 views today

Read More...