The Power Query Text function Text.RemoveRange is used to remove a specified number of characters from a text, starting at a specified position. Syntax Text.RemoveRange(text… Read More »Power Query Text.RemoveRange Function
Power Query text function Text.Remove allow us to remove particular characters from string. Text.Remove(text as nullable text, removeChars as any) as nullable text text: given… Read More »Remove characters from string in Power Query
Power Query has various in-built functions which help us in transforming and preparing the data. To extract the first and last characters from string we… Read More »How to get first and last characters from string in Power Query
Power Query provides a set of tools and functions to transform your data. Here we will see how to insert a text or you can… Read More »How to insert text into an existing text 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
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
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
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
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
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
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
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
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 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
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
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
You can check multiple values in any list using IN operator in Power Query. Lets say, you have a requirement to check for specific categories… Read More »IN operator in Power Query M code
Microsoft Power BI team has introduced an AI Insights in Power BI in November 2019 update, which is collection of pre trained machine learning models… Read More »AI Insights in Power BI
When data is loaded into Power BI model, most of the time Power BI automatically detect the data type of columns. Some times Power BI… Read More »Change column data type 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