Loading...

Follow Yodalearning on Feedspot

Continue with Google
Continue with Facebook
or

Valid
Yodalearning by Yoda Learning - 2M ago

Power Query is one of the most powerful features in Power BI and the easiest to learn. It is used for cleaning & transforming the data downloaded from ERP or accounting systems and display it in a report for Power BI to work with. You can learn more tips & tricks in our Power Query […]

The post Power Query Tips & Tricks appeared first on Yodalearning.

Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

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 […]

The post Learn How to Display A Monospaced Font in Power Query appeared first on Yodalearning.

Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

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 […]

The post How to Add Comments In M Using Power Query appeared first on Yodalearning.

Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

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 as descriptions in the Applied Steps pane. Comments In Query Steps […]

The post Top 5 Steps to do Comments In Query Steps appeared first on Yodalearning.

Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Power Query also allows you to create a list query from a data table available. The column from the given data table can be used to create a list query. This can be explained with the help of an example. Creating A List Query From A Table Column Here, we have a data table containing […]

The post Steps to Create A List Query From A Table Column appeared first on Yodalearning.

Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

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 Parameters By Power Query Step 1: Create a List […]

The post How to Manage Parameters in Power Query appeared first on Yodalearning.

Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

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, […]

The post Learn How to Rename A Column Using Power Query appeared first on Yodalearning.

Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

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 With 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 […]

The post Learn How to Merge Columns in Power Query appeared first on Yodalearning.

Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

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. […]

The post Top 3 Steps to Append Queries Using Power Query appeared first on Yodalearning.

Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

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 […]

The post Steps to Format Columns Using Power Query appeared first on Yodalearning.

Read Full Article

Read for later

Articles marked as Favorite are saved for later viewing.
close
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Separate tags by commas
To access this feature, please upgrade your account.
Start your free month
Free Preview