Home ยป Archives for SqlSkull

SqlSkull

ISBLANK Function DAX

ISBLANK Function is a POWER BI Information function in DAX that checks whether a value is blank, and returns TRUE If value is blank else… Read More »ISBLANK Function DAX

SELECTEDVALUE Function DAX

SELECTEDVALUE Function is Power BI Filter Functions in DAX which returns the value when there is only one value in the specified column else it… Read More »SELECTEDVALUE Function DAX

CONTAINS Function DAX

CONTAINS function is a Power BI Information function in DAX which returns TRUE if there exists at least one row where all columns have specified… Read More »CONTAINS Function DAX

CALENDARAUTO Function DAX

CALENDARAUTO funtion is a Power BI Date and Time Function in DAX which returns table with single column which contains a contiguous set of dates.… Read More »CALENDARAUTO Function DAX

FIND Function DAX

FIND Function is a Power BI TEXT function in DAX which returns the starting position of one text string within another text string. FIND function… Read More »FIND Function DAX

ADDCOLUMNS function DAX

ADDCOLUMNS is a POWER BI Table Manipulation Functions in DAX which is used to add a calulated columns in table. Basically, ADDCOUMNS returns a table… Read More »ADDCOLUMNS function DAX

DATATABLE Function DAX

DATATABLE function is a Power BI Table manipulation function in DAX which allows us to create a table. Using Datatable function, You can define column… Read More »DATATABLE Function DAX

Show Hide Measures in Line chart visuals using slicer in Power BI

Show and Hide Measures in Line chart visuals based using slicer If you are working on Line and clustered column chart, or line and stacked… Read More »Show Hide Measures in Line chart visuals using slicer in Power BI

SQL sp_helptext

SQL sp_helptext is a SQL Server System stored procedure that displays the the definition of any SQL Server objects. You can see the definition of… Read More »SQL sp_helptext

How to Encrypt a Stored Procedure in SQL Server

Encrypting a SQL Server Stored Procedure If you have any complex business logic that you want to keep secure and hide from end user due… Read More »How to Encrypt a Stored Procedure in SQL Server

SQL Over Clause

SQL OVER clause allows the use of aggregation without using a group by clause. OVER caluse aggregate rows across groups of another field using the… Read More »SQL Over Clause

SQL Server @@Servicename

SQL @@servicename is SQL Server configuration function which returns the name of the registry key under which SQL Server is running. This function does not… Read More »SQL Server @@Servicename

SQL ROUND Function

The SQL ROUND function is a SQL Mathematical Function which is used to round a number to a specified length or precision. It returns a… Read More »SQL ROUND Function