Need Help? Chat with us

Category

Power BI

How to Use First Row As Headers in Power Query

One of the features of the Power Query is that it allows you to promote the first row as column headers. Let’s take an example where you have the data set as shown below. Use First Row As Headers By Power Query Here, the headers are not meaningful as it is showing the headers as Column1,...
Read More

Split Column in Power Query

Power Query helps you to perform a series of steps to modify your data. One of the steps is to split a column by the number of characters easily. How to Split Column in Power Query This is helpful when you have columns that you want to split by an equal number of characters, for...
Read More

Power BI Dashboard vs. Power BI Report | BI Dashboard

Power BI dashboard is usually known as a canvas and it can have only one page to tell a story using visualizations. Since it is restricted to one page, a perfect Power BI dashboard contains only the most important fundamentals of the story. So before creating the Power BI Dashboard or Report, let’s know What...
Read More

Create Power BI Layouts – Power BI Tips and Tricks

Power BI has this excessive functionality where you can go and download preset layouts which make your Power BI reports look more effective. There is a simple trick to create these Power BI layouts. You can create layouts in PowerPoint and then convert them into images. After that, you can insert them into your Power...
Read More

Complete Guide of Power BI Download and Power BI Installation Steps

Power BI Download and Installation Guide Microsoft Power BI Desktop is designed for the data analyst. It consists of the interactive visualizations, with industry-leading data query and modeling built-in. You can generate and publish your reports to Power BI. Power BI Desktop helps you authorize others with timely critical information, anytime, anywhere. and Checkout Power...
Read More

Power BI Architecture | Power BI Security

Microsoft Power BI is a self-service analytics tool. It is responsible for covering various topics of analytics such as data analysis, performing ETL, preparing datasets, modeling the data, report building, visualizations of the reports, and much more. To learn Power BI and deep dive into the possibilities, it is essential to learn its Architecture. This...
Read More

Keep Duplicate Records in Power Query

Power Query in Power BI allows you to perform a series of steps to transform your data. One of the steps amongst this is to keep duplicate records. Keep Duplicate Records In Power Query We generally take out duplicate lines but if we need to keep and check what the duplicates are, Power Query allows...
Read More

Power Bi Dax Deduplication Based On Column

To do Power BI DAX deduplication based on column or to eliminate the duplicate data from a data set, Power BI has a weapon called DAX. Data Analysis Expressions (DAX) is a library of functions and operators that can be united to create formulas and expressions in Power BI Desktop. We can deduplicate any data...
Read More

Learn How to Create Index Column Using Power Query

There is one more interesting feature of Power Query where it lets you add an index column that serves as a row counter to your data. Power Query Helps To Create Index Column Let’s go through the steps in detail with an example. Our sample data consists of Months and revenue data as shown in the...
Read More

How to do Duplicate Columns in Power Query

You can also duplicate the columns easily using the Power Query Editor in Power BI. This can be helpful when you have columns that you want to duplicate & make some temporary/permanent alterations to it in the Power Query Editor but not to your source data. In this tutorial, we learn 3 cool steps to...
Read More

51 Amazing Power Query Tips & Tricks | Power Query Tutorial

Learn Power Query Tips and Tricks. 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...
Read More

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? With 3 easy steps, you can quickly display a monospaced font with Power Query. For more Power Query Tips & Tricks you can check our highly appreciated Power...
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 ‘*/’. Comment plays an important role to understand the code. In the future, if you want to change some part of code or want to share your code with your friend, who can easily understand...
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

Steps to Create A List Query From A Table Column

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...
Read More

How to Manage Parameters in Power Query

Learn How to Manage Parameters in Power Query Step-by-Step. Power Query can create a query parameter and link it 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 the list query explained...
Read More

Learn How to Rename A Column Using Power Query

One of the important and most needed features of Power Query is the Renaming Column Headers. Many people facing issues to rename column names using Power Query. We show you step by step process, how you can rename a column in Power Query very easily. To get in-depth knowledge related to Power Query and its...
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...
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 years 2015 and 2016. We want to combine these two data tables together....
Read More

Top 5 Steps to Extract Age Using Date in Power Query

Learn How 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. There are more similar functions that are very much useful in Power Query for Data Cleaning and Data...
Read More
1 2 3 4