Complete Guide of Power BI Download and Power BI Installation Steps
2 Mins read
Power BI Download and Installation Guide Microsoft Power BI Desktop is designed for the data analyst. It consists of the interactive visualizations,…
Keep Duplicate Records in Power Query
1 Mins read
Power Query in Power BI allows you to perform a series of steps to transform your data. One of the steps amongst…
Power Bi Dax Deduplication Based On Column
3 Mins read
To do Power BI DAX deduplication based on column or to eliminate the duplicate data from a data set, Power BI has…
Learn How to Create Index Column Using Power Query
1 Mins read
There is one more interesting feature of Power Query where it lets you add an index column that serves as a row…
How to do Duplicate Columns in Power Query
1 Mins read
You can also duplicate the columns easily using the Power Query Editor in Power BI. This can be helpful when you have…
51 Amazing Power Query Tips & Tricks | Power Query Tutorial
11 Mins read
Learn Power Query Tips and Tricks. Power Query is one of the most powerful features in Power BI and the easiest to…
How to Add Comments In M Using Power Query
1 Mins read
You can add comments to your code either with single-line comments that start with ‘//’ or multi-line comments that start with ‘/*’…
Steps to Create A List Query From A Table Column
1 Mins read
Power Query also allows you to create a list query from a data table available. The column from the given data table…
How to Manage Parameters in Power Query
1 Mins read
Learn How to Manage Parameters in Power Query Step-by-Step. Power Query can create a query parameter and link it to the List…
4 Easy Steps to Concatenate Columns in Power Query
1 Mins read
Merging columns is also a feature of Power Query which is very useful for transforming data. You can use this feature easily…
Top 3 Steps to Append Queries Using Power Query
1 Mins read
You can even append queries in Power Query. This feature is very useful if you want to combine two data tables together….
Top 5 Steps to Extract Age Using Date in Power Query
1 Mins read
Learn How to Extract Age using Date in Power Query. This is an amazing feature as it allows you to extract the…
How to Create A Sequential List Using Power Query
1 Mins read
The Power Query M language allows you to create a list containing a sequence of numbers or characters very easily. This is…
Disable Relationship Detection for Beginners in Power Query
1 Mins read
Disable Relationship Detection for Beginners in Power Query. This is another feature of Power Query that will speed up your queries. When…
Advanced Editor With Power Query
1 Mins read
Advanced Editor With Power Query can perform a lot of complex steps with any kind of data source. However wouldn’t it be…
Use Excel's Right Function With 'M' To Extract Left Side Data
1 Mins read
If you want to use the Excel LEFT Function in Power Query, then you can’t directly go for it. This is because…
Get The Length Of Strings Using 'M' in Power Query
1 Mins read
Get the Text Length using Power Query M. If we want to use the Excel LEN function to get the length of…
Best Ways to Add Column From Examples in Power Query
1 Mins read
Sometimes we need to transform the text from a huge data table which is not directly possible. But, with Power Query, you…
Best Ways to Import Data From XML in Power Query
1 Mins read
You can easily load the data files like Excel spreadsheets in Power Query. But what if your data source is not an…
Split First & Last Name Using Power Query
1 Mins read
Sometimes, when you have a data table which includes full names of candidates in one column and you want to separate the…