REMOVEFILTERS Function DAX
REMOVEFILTER function is a Power BI filter function in DAX, It removes filters from the specified tables or columns. It can only be used to… Read More »REMOVEFILTERS Function DAX
Home » Archives for Pradeep Raturi »
Pradeep Raturi
I have 11+ years of working experience in Business Intelligence Data Modelling, Power BI, SQL Server, SSRS, SSIS, Azure Data Factory, Power Apps.
Split columns by positions
Power Query allows you to split a column with various options, one of them is split columns by positions which split a text columns at… Read More »Split columns by positions
TOTALYTD Function DAX
TOTALYTD is a Power BI time intelligence function in DAX, which evaluates the year-to-date value of the expression in the current context. DAX SYNTAX TOTALYTD(<expression>,<dates>[,<filter>][,<year_end_date>]) expression… Read More »TOTALYTD Function DAX
Difference between clustered index and non clustered index
SQL Server indexes are used by queries to find data values quickly in tables and views. Basically it speed up the queries performance. You can… Read More »Difference between clustered index and non clustered index
SQL NULLIF
SQL NULLIF expression compares two expression and returns a null value if the two specified expressions are equal, else it returns the first expression. NULLIFÂ … Read More »SQL NULLIF
SET STATISTICS IO
SQL STATISTICS IO is a set statement , when it is enabled it causes SQL Server to display information about the amount of disk activity… Read More »SET STATISTICS IO
SQL IS NULL
The IS NULL is used in SQL to find a NULL value. It returns TRUE if a NULL value is found, otherwise it returns FALSE.… Read More »SQL IS NULL
SQL IS NOT NULL
The IS NOT NULL is used in SQL to find a non-NULL value. It returns TRUE if a non-NULL value is found, otherwise it returns… Read More »SQL IS NOT NULL
REPLACE Function DAX
REPLACE function is a Power BI text function in DAX, which replaces part of a text string based on the number of characters you specify,… Read More »REPLACE Function DAX
Calculated Columns
Microsoft Power BI allows you to create a calculated columns means you can add a new column to an existing table in your data model,… Read More »Calculated Columns
Pivot Columns in Power BI
Pivot column is a feature available in Power Query which allows you turn rows to columns. Basically, Power Query groups each unique values and performs… Read More »Pivot Columns in Power BI
How to Update from Select Statement in SQL
SQL Server update statement is used used to modify an existing records in a table, you can also update records in table based on some… Read More »How to Update from Select Statement in SQL
PATHREVERSE function DAX
PATHREVERSE function is a Power BI Parent and Child function in DAX which returns the item at the specified position from a string resulting from… Read More »PATHREVERSE function DAX
PATHITEM Function DAX
PATHITEM function is a Power BI parent and child function in DAX which returns the item at the specified position from a string resulting from… Read More »PATHITEM Function DAX
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… Read More »PATHLENGTH Function DAX
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… Read More »PATH Function DAX
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,… Read More »Insert multi language data in table
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.… Read More »SQL Random Number
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… Read More »How to insert the result of a stored procedure into table
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… Read More »SQL Delete TOP