fbpx
[email protected] +1 203-349-9909 / +91-8080042523

Tag

Power Excel

Learn How to Display A Monospaced Font in Power Query

Normally data is viewed in the Unicode Font for any kind of data. But do you know you can also change this font to a monospaced font? Display A Monospaced Font With Power Query Power Query has a solution for this also. If you want to use another font other than Unicode font then follow...
Read More

How to Add Comments In M Using Power Query

You can add comments to your code either with single-line comments that start with ‘//’ or multi-line comments that start with ‘/*’ and end with ‘*/’. Adding Comments In M With Power Query Let’s take an example to see how it works. Step 1: Load Data in Power Query Load the data in Power Query first to apply comments in...
Read More

Top 5 Steps to do Comments In Query Steps – Power Query Tutorial

Learn How to do Comments in Query Steps with Power Query. The new feature of Power Query allows you to add descriptions to each step in the Applied Steps pane. The step descriptions become comments in the M code in Power Query. If you write M code in the Advanced Editor window, then your comments appear...
Read More

How to Manage Parameters in Power Query

Learn How to Manage Parameters in Power Query Step-bu-Step. Power Query can create a query parameter and link to the List Query. This is one of the most unknown features of Power Query. Let us study this unique feature along with an example. We have considered the same example of list query explained above. Manage...
Read More

Learn How to Rename A Column Using Power Query

One of the important and most needed features of Power Query is Renaming Column Headers. You can rename a column in Power Query very easily. Rename A Column With Power Query Let’s observe the below steps to rename column headers- Step 1: Load Data in Power Query When you load the data in Power Query,...
Read More

Learn How to Merge Columns in Power Query

Merging columns is also a feature of Power Query which is very useful for transforming data. You can use this feature easily by following below steps. Merge Columns in Power Query Step 1: Select the Columns in Power Query for Merging If you have a data table as shown below and you want to merge...
Read More

Top 3 Steps to Append Queries Using Power Query

You can even append queries in Power Query. This feature is very useful if you want to combine two data tables together. Let us understand this using an example. As shown in the below picture, you have two sales data for the year 2015 and 2016. We want to combine these two data tables together....
Read More

Steps to Format Columns Using Power Query

Another important feature of Power Query is Formatting Columns. There are various formatting options available in Power Query for columns like Trim, Clean, Add Prefix, Uppercase etc. In this example, we are going to see how to capitalize each word from the column using the formatting feature. Format Columns By Power Query Step 1: Select...
Read More

Top 5 Steps to Extract Age Using Date in Power Query

This is an amazing feature as it allows you to extract the age out of the date provided. Let us elaborate on this feature using an example. Extract Age Using Date With Power Query Here, we have a data table containing employee information which includes their Date of the Birth column. If you want to...
Read More

How to Create Grouped Serial Numbers In Power Query

If we have data for products and we want a unique identifier for each product name in the list. But as you can see below each product appears multiple times in the data table. Create Grouped Serial Numbers In Power Query But we want to keep the same serial number for the product each time...
Read More

How to Create A Sequential List Using Power Query

The Power Query M language allows you to create a list containing a sequence of numbers or characters very easily. This is possible when you are defining lists by using expressions in the format- Create A Sequential List With Power Query {lowest_integer..highest_integer} Let us take an example to understand this feature. Step 1: Add Custom...
Read More

How to Navigate Query Editor Using Power Query

While using Power Query, you might’ve come across a step that reads ‘Navigation’  in Applied Steps pane and it is automatically created by Power Query. But, do you know what it is used for? Navigate Query Editor Using Power Query The code generated by this step is = Source{[Item=”Sheet1″,Kind=”Sheet”]}[Data] This is one of the ways...
Read More

How to Edit A Query Using Power Query

Power Query also allows you to edit a query that you have already generated. Let’s take an example. Suppose you have a data table as shown below. Editing A Query By Power Query This is an employee data and you have to create the post for each employee based on their experience given in the...
Read More

Disable Relationship Detection for Beginners in Power Query

This is another feature of Power Query that will speed up your queries. When you load your data into the data model from power query, Excel will try to find and build relationships between the new data and other tables in the present in the data model. Thus, it will take extra processing time and will...
Read More

Delete Steps Until End By Power Query

If you want to delete some steps, you can do it in one shot. The Power Query Delete Until End feature helps to delete as many steps up to the end in one click. Delete Steps Until End By Power Query Let us understand this feature with the help of an example. Step 1: Load...
Read More

Advanced Editor With Power Query

Power Query can perform a lot of complex steps with any kind of data source. However wouldn’t it be fun unless you understand what is happening under the cover. Advanced Editor With Power Query Let’s go through the steps in detail to understand the magic of Power Query. Step 1: Load the data into Power...
Read More

Data Type Conversion With ‘M’ Using Power Query

Sometimes it happens that the things we want to do are not built in the user interface.  But Power Query’s programming language M has made this possible. Data Type Conversion With ‘M’ Using Power Query One of the unique functionality of M is that it takes data types very seriously. If we try to concatenate a text...
Read More

Use Excel’s Right Function With ‘M’ To Extract Left Side Data

If you want to use the Excel LEFT Function in Power Query, then you can’t directly go for it. This is because the Excel LEFT Function it is not supported in M. Use Excel’s Right Function With ‘M’ To Extract Left Side Data But there is an alternate way for using the LEFT Function in...
Read More

Use Excel’s Right Function With M To Extract Right Side Data

If we want to use the Excel’s RIGHT Function, it is not possible as it is not supported in M. But we can use the RIGHT Function in M in other way using Power Query and the Text. End formula! Use Excel’s Right Function With M To Extract Right Side Data Let’s see how to...
Read More

Get The Length Of Strings Using M in Power Query

If we want to use the Excel LEN Function to get the length of strings, it is not supported in M. Let us see how to use the LEN Function in M to get the length of strings. Get The Length Of Strings Using M Step 1: Select the Name Column First, load the data...
Read More
1 2
Power bi vs SSRS
Power BI vs. SSRS | Difference between Power BI and SSRS
September 20, 2019
Tableau Interview Questions
Tableau Interview Questions and Answers [Q&A]
September 18, 2019
Power BI Data Sources
Power BI Data Sources and Power BI Services
September 16, 2019
What is Power BI_ _ Introduction to Microsoft Power BI
What is Power BI? | Introduction to Microsoft Power BI
September 13, 2019
POWER BI COMPONENTS
Power BI Components and Building Blocks of Power BI
September 13, 2019
Basics of Power BI DAX Function
Basics of Power BI DAX | List of Power BI DAX Function with Example
September 9, 2019
Power BI vs. Tableau
Power BI vs Tableau – Comparing Functionality, Pricing and Support
September 3, 2019
Business Analyst Interview Questions
Business Analyst Interview Questions & Answer (Q&A)
July 25, 2019
Data Analyst Interview Questions and Answers
Data Analyst Interview Questions and Answers [Q&A]
July 25, 2019
Power BI Dashboard vs. Power BI Reports
Power BI Dashboard vs. Power BI Report | BI Dashboard
July 24, 2019
Create Power BI Layouts step-by-step
Create Power BI Layouts – Power BI Tips and Tricks
July 24, 2019
Create Power BI Dashboard
5 Steps to Create your first Power BI Dashboard | Power BI Dashboard
July 24, 2019
Power BI Templates
Power BI Templates | Download Power BI Template
July 24, 2019
Complete Guide of Power BI Download and Power BI Installation Steps
July 24, 2019
Advanced Power BI Tips and Tricks
Complete Power BI Tips and Tricks – Power BI Dashboard Tutorials
July 24, 2019
Power Query Tips and Tricks
50 Amazing Power Query Tips & Tricks | Power Query Tutorial
March 8, 2019
How to Add Comments In M Using Power Query
March 4, 2019
Top 5 Steps to do Comments In Query Steps – Power Query Tutorial
March 4, 2019
Steps to Create A List Query From A Table Column
March 4, 2019
How to Manage Parameters in Power Query
March 4, 2019