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

Day

March 2, 2019

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

Replicating Excel’s Find Function With ‘M’ in Power Query

In the above example, you learned how to concatenate the columns using the M language. Unfortunately, not all of the Excel’s formulas can be used in M query. Replicating Excel’s Right Function With ‘M’ Using Power Query For instance, if we want to use the Excel’s FIND Function to find a specific character in the...
Read More

5 Steps to Concatenate Data using ‘M’ in Power Query

How to use power query concatenate function? There are times when we want to perform such tasks that are not built in the user interface i.e. features that are not available on the ribbon. But still, this can be possible with Power Query’s programming language which is called M language. Power Query Concatenate Data using...
Read More

Best Ways to Add Column From Examples in Power Query

Sometimes we need to transform the text from a huge data table which is not directly possible. But, with Power Query, you can easily do it using Add Column from Examples feature. Add Column From Examples By Power Query Step 1– Select the column on which you want to apply changes Suppose you have a...
Read More

Read how to Add Conditional Column in Power Query

In Power Query, there is a feature to add a new column called Conditional Column feature. You can define IF-THEN-ELSE conditions to add the conditional column. When the conditions are fulfilled, the conditional column will automatically demonstrate the values that you have specified using IF-THEN-ELSE conditions. Add Conditional Column Using Power Query Let’s take an...
Read More

Top Ways to Import Data From Text in Power Query

As you can import the data from CSV, the same way you can import the data from the text file. The reason is that Power BI provides the same option to import the CSV file as well as a text file. Let us understand this with the help of below steps. Import Data From Text...
Read More

Best Ways to Import Data From CSV in Power Query

Now you know how to import data from an XML file in Power Query. But what if your data source is in the form of CSV file? There is no need to worry if you have your data inside a CSV file (Comma Separated Values). This is because it’s very easy to import data from CSV...
Read More

Best Ways to Import Data From XML in Power Query

You can easily load the data files like Excel spreadsheets in Power Query. But what if your data source is not in Excel spreadsheet? Import Data From XML Using Power Query It’s very usual nowadays to get data from a company’s accounting or sales system in the XML format. If the data is inside an...
Read More

Top 5 Ways to Import Web Data in Power Query

The good thing with Power Query is that there are multiple ways to pull in data. Import Web Data Using Power Query One of the way is to get data from the internet by using the importing web data feature.  Let us see how we can parse a webpage and use it for Power Query....
Read More

Learn How to Filter Records Using Power Query

Filter records is a feature of Power Query that allows you to filter the data from your data table. Let’s see how to filter the records in Power Query with an example. Filter Records By Power Query Step 1: Load Data in Power Query Sometimes the data table is too huge and you do not want...
Read More

How to Unpivot Data Using Excel Power Query

Power Query allows you to extract data from any source, clean and transform the data and then load it to another sheet within the Power BI Designer canvas. Unpivot Data With Excel Power Query One of the best features of the Power Query is to Unpivot Columns. Unpivot Columns feature transforms columns with similar characteristics...
Read More

Consolidate Multiple Excel Sheets Using Power Query

If you have multiple Excel worksheets that are in the same format and their underlying differences are their values and dates (e.g. January Sales List, February Sales List, March Sales List etc), then we can easily consolidate all the worksheets into one. Consolidate Multiple Excel Sheets By Power Query Let us understand this step by...
Read More
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
Learn How to Display A Monospaced Font in Power Query
March 4, 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