Error handling in Power Query
Power Query is a very powerful tool. It has many inbuilt functions that helps you in data transformation and data preparation. Error Handling allows you… Read More »Error handling in Power Query
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.
Create custom function to get two dates difference
This article demonstrate how to create a custom function in Power Query that returns the difference of two dates. Custom function takes a set of… Read More »Create custom function to get two dates difference
Add comments to Power Query steps
Whenever you do a transformation in Power Query, it adds a steps for each transformations. It is always a good practice to add a short… Read More »Add comments to Power Query steps
Handle NULL values in Power Query
This article demonstrate how to handle NULL values in data. Having null values in data may impact calculations and produce wrong result. As you can… Read More »Handle NULL values in Power Query
Replace multiple values in one column Power Query
Power Query allows you to replace any values with new values, you might have used power query replace values option which replace the old value… Read More »Replace multiple values in one column Power Query
SQL Interview Questions
A series of SQL most asked interview questions and answers for freshers and experienced professionals will help you prepare and cracking SQL interview. LeetCode –… Read More »SQL Interview Questions
Add Prefix and Suffix to Value in Power Query
Power Query helps you to transform your data, there are various in-built Power Query M code function that can be useful to transform you data… Read More »Add Prefix and Suffix to Value in Power Query
Running totals in Power Query
A running totals or cumulative totals is a sequence of partial sum of values in any given table. It just add up the values as… Read More »Running totals in Power Query
Remove matching rows using Power Query
Removing the matching rows or occurrence of specified rows from the table using Power query is very easy as Power Query provides in-built function named… Read More »Remove matching rows using Power Query
Difference between PBIX, PBIT and PBIDS file format in Power BI
A PBIX, PBIT, and PBIDS are file extensions used in Microsoft Power BI. Lets explore and see the difference between each of them one by… Read More »Difference between PBIX, PBIT and PBIDS file format in Power BI
Reset Identity column value
An identity column in table generates key values automatically based on the current seed and increment, and the benefit of creating an identity column is… Read More »Reset Identity column value
Difference between two dates in Power Query
This article demonstrate how to get the difference between to dates in Power Query. You can use the Power Query Duration function that is Duration.Days… Read More »Difference between two dates in Power Query
Date Functions in Power Query
Date functions helps you to create and manipulate the part of date such as date, datetime, and datetimezone values. There are various inbuilt date functions… Read More »Date Functions in Power Query
Replace multiple columns values in Power Query
This article demonstrate how to replace multiple columns value at once in Power Query. Lets say, you need to check if column value is blank… Read More »Replace multiple columns values in Power Query
Remove duplicate and keep latest record in table
In this article we will see how to remove duplicate record and keep the latest record in table using Power Query. As you can see… Read More »Remove duplicate and keep latest record in table
SQL NOT EXISTS
The SQL NOT EXISTS Operator is used to check the existence of any record in a subquery. The NOT EXISTS operator returns true if the… Read More »SQL NOT EXISTS
Change gallery item color based on value in power apps
This article demonstrates how to change the item color in a gallery based on its value. Showing the items in a different color can be… Read More »Change gallery item color based on value in power apps
Sort Items in gallery Power Apps
This Article demonstrate how to sort items in gallery control based on item value. You can sort values either in ascending or descending order. You… Read More »Sort Items in gallery Power Apps
Highlight selected item in gallery power apps
This article demonstrates how to highlight the selected item in gallery control in Power Apps. As you can see below app screen, there is one… Read More »Highlight selected item in gallery power apps
Email Validation in Power Apps
This article demonstrates how to validate if email is not in correct format in Power Apps. It is must to have validation on data while… Read More »Email Validation in Power Apps