Power BI November 2021 update
Microsoft Power BI team has recently released November updates such as page and bookmark navigators, new format pane preview feature, sort legend, new text box… Read More »Power BI November 2021 update
132 total views
HTML Color picker
HTML Color picker, you can search colors either by color name or color hexacode 175 total views, 1 views today
175 total views, 1 views today
Change matrix background color based on value
In this article you will see how to change the background color for specific rows in a matrix based on values in column. Here, we… Read More »Change matrix background color based on value
147 total views, 1 views today
How to get the size of table in SQL
There are multiple ways to get the size of table in SQL Server. Lets take a look on them one by one. Using sp_spaceused system… Read More »How to get the size of table in SQL
217 total views
Insert same rows multiple times in table
Sometimes you need to insert same row multiple times in a table. There are many ways to do that but here we will see one… Read More »Insert same rows multiple times in table
351 total views
Conditional Column in Power BI
A conditional column is a column that is generated based on a condition imposed on an existing column in data model. In general, conditional column… Read More »Conditional Column in Power BI
282 total views, 1 views today
Custom column in Power BI
Power BI Custom column adds a new column in data model based on the existing columns in data model. You can create a custom column… Read More »Custom column in Power BI
389 total views, 6 views today
How to compare column names in two tables in SQL
Assume that, you have two tables and you are asked to find out the columns which exists in both table with same name or column… Read More »How to compare column names in two tables in SQL
693 total views, 5 views today
How to find leading and trailing spaces in SQL Server ?
You may have faced a situation where you are asked to find values in a column with leading or trailing spaces or remove the leading… Read More »How to find leading and trailing spaces in SQL Server ?
338 total views, 3 views today
How to show last refresh date in Power BI
Showing a last refresh date and time in Power BI report let you know how fresh your report data is as sometimes report viewer can… Read More »How to show last refresh date in Power BI
383 total views
Search string in xml
How to search for string within xml column in SQL table? As you can see here we have a sample table having categories and products… Read More »Search string in xml
257 total views, 5 views today
Refresh error from changing column names in data source
You may have faced a refresh error when a column name is changed in data source, it happens in such scenario when you have renamed… Read More »Refresh error from changing column names in data source
581 total views, 5 views today
Generate a range of numbers between two numbers in SQL Server
Sometimes, you need to show range of numbers or may be asked to generate a range of numbers between two numbers in SQL Server. Well,… Read More »Generate a range of numbers between two numbers in SQL Server
745 total views, 3 views today
Export Measures and Calculated columns
Documenting DAX formulas is always a good practice as it saves a lot of time in various scenario such as when your PBI report having… Read More »Export Measures and Calculated columns
1,626 total views, 5 views today
Formatting DAX
Formatting a DAX is good practice as it makes your DAX code well defined and readable. If you have written a DAX code which is… Read More »Formatting DAX
489 total views, 1 views today
Lost update problem in concurrent transations
A lost update problem occurs in concurrent transactions, when two transactions try to read and update the same column on the same row within a… Read More »Lost update problem in concurrent transations
1,097 total views, 6 views today
SQL Return
SQL Return is a control-of-flow language keyword which is used to exit unconditionally from a query or stored procedure. It can be used at any… Read More »SQL Return
381 total views, 1 views today
Aggregate Transformation Basic Mode in SSIS
The Aggregate transformation applies aggregate operations such as maximum, minimum, average, sum, and count to column values and copies the results to the transformation output.… Read More »Aggregate Transformation Basic Mode in SSIS
1,212 total views, 1 views today
Send Multiple files to FTP Server in SSIS
This article demonstrate how to send multiple files from local system folder to FTP Server. If you want to send only single file from your… Read More »Send Multiple files to FTP Server in SSIS
695 total views
Send file to FTP Server in SSIS
This article demonstrate how to send, or upload file from local system to FTP Server. SSIS allows you to use FTP task which helps you… Read More »Send file to FTP Server in SSIS
892 total views, 2 views today