NEW! FREE 15 Hours Microsoft Excel Course! View now 

YodalearningYodalearning
Menu
  • Home
  • Excel
    • ESSENTIALS 1
      • Shortcuts
      • Lookup Formulas
      • Pivot Table
      • Data Cleaning
    • ESSENTIALS 2
      • Charts
      • Dashboard
      • Consolidation
    • VBA MACROs
      • Basics
      • Readymade Codes
      • Essential Theory
    • CASE STUDIES
      • HR & L&D
      • Sales & Marketing
      • IT & Project Management
      • Finance & Audit
      • Office 365
  • Power BI
  • Webinar
  • Courses
  • Login

Browsing tag

Power Query

Power BITutorials

Power Query Helps In Transposing Data

By Yoda Learning
May 1, 2020
1 Mins read
Power BITutorials

Read How to Remove Rows With Errors Using Power Query

By Yoda Learning
December 28, 2019
1 Mins read
Do you know that Power Query can clean your data and remove rows that have inaccurate data? If you are not aware…
Power BITutorials

Learn How to Split Queries In Power Query

By Yoda Learning
December 28, 2019
1 Mins read
As explained in the above example, we have generated a conditional column for the given query. If we want to split this…
Power BITutorials

How to Use First Row As Headers in Power Query

By Yoda Learning
December 27, 2019
1 Mins read
One of the features of the Power Query is that it allows you to promote the first row as column headers. Let’s take…
Power BITutorials

Split Column in Power Query

By Yoda Learning
December 27, 2019
2 Mins read
Power Query helps you to perform a series of steps to modify your data. One of the steps is to split a…
Power BITutorials

Keep Duplicate Records in Power Query

By Yoda Learning
December 20, 2019
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 BITutorials

Power Bi Dax Deduplication Based On Column

By Yoda Learning
December 17, 2019
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…
Power BITutorials

Learn How to Create Index Column Using Power Query

By Yoda Learning
December 12, 2019
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…
Power BITutorials

How to do Duplicate Columns in Power Query

By Yoda Learning
December 12, 2019
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…
Power BITutorials

51 Amazing Power Query Tips & Tricks | Power Query Tutorial

By Yoda Learning
December 8, 2019
13 Mins read
Learn Power Query Tips and Tricks. Power Query is one of the most powerful features in Power BI and the easiest to…
Power BITutorials

Steps to Create A List Query From A Table Column

By Yoda Learning
December 4, 2019
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…
Power BITutorials

Best Ways to Add Column From Examples in Power Query

By Yoda Learning
December 2, 2019
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…
Power BITutorials

Best Ways to Import Data From XML in Power Query

By Yoda Learning
December 2, 2019
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…
Power BITutorials

Learn How to Replace Values in Power Query

By Yoda Learning
December 1, 2019
1 Mins read
There is a cool feature of Power Query which is known as ‘Replace Values’ feature. As the name suggests, it can replace…
Power BITutorials

How to Add Conditional Column in Power Query

By Yoda Learning
March 2, 2019
2 Mins read
How to Add Conditional Column in Power Query Step-by-Step. [toc] In Power Query, there is a feature to add a new column…
Power BITutorials

Top Ways to Import Data From Text in Power Query

By Yoda Learning
March 2, 2019
1 Mins read
As you can import the data from Text/CSV, the same way you can import the data from the text file. The reason…
Power BITutorials

Learn How to Filter Records Using Power Query

By Yoda Learning
March 2, 2019
1 Mins read
Filter records are a feature of Power Query that allows you to filter the data from your data table. Let’s see how…
Power BITutorials

How to Unpivot Data Using Excel Power Query

By Yoda Learning
March 2, 2019
1 Mins read
Power Query allows you to extract data from any source, clean and transform the data and then load it to another sheet…
Power BITutorials

Consolidate Multiple Excel Sheets Using Power Query

By Yoda Learning
March 2, 2019
1 Mins read
If you have multiple Excel worksheets that are in the same format and their underlying differences are their values and dates (e.g….
Power BITutorials

Learn How to do Reverse Rows Using Power Query

By Yoda Learning
March 1, 2019
1 Mins read
Sometimes you need to show the data in a reverse form for some of the other reasons. It’s not easy to reverse…
Older posts
  • Latest posts

    • ExcelExcel VBA Code

      Create A Table Of Contents By VBA Code

      January 14, 2021
      1 Mins read
    • ExcelExcel VBA Code

      Save Each Worksheet as a Separate PDF

      January 8, 2021
      1 Mins read
    • Power BITutorials

      Opportunity Analysis Power BI Dashboard

      January 4, 2021
      1 Mins read
  • Popular

    • Excel Formulas & Functions in PDF List

      June 14, 2020
    • 220+ MS Excel Shortcuts Keys in PDF | Excel Keyboard Shortcuts

      December 17, 2020
    • Unprotect Excel | Excel Password Remover Online

      May 20, 2020
    • [How to] Calculate Profit Margin in Excel | Profit Margin Formula

      May 6, 2020
  • Subscribe and Follow

  • About

    Learn to [Analyse], [Visualise] and [Automate] using the most commonly used tools in organisations globally i.e. Excel & Power BI.

  • Recent Posts

    • Create A Table Of Contents By VBA Code
    • Save Each Worksheet as a Separate PDF
    • Opportunity Analysis Power BI Dashboard
    • Procurement Analysis Power BI Dashboard
    • Retail Analysis Power BI Dashboard
  • Navigation

    • Home
    • Excel
      • ESSENTIALS 1
        • Shortcuts
        • Lookup Formulas
        • Pivot Table
        • Data Cleaning
      • ESSENTIALS 2
        • Charts
        • Dashboard
        • Consolidation
      • VBA MACROs
        • Basics
        • Readymade Codes
        • Essential Theory
      • CASE STUDIES
        • HR & L&D
        • Sales & Marketing
        • IT & Project Management
        • Finance & Audit
        • Office 365
    • Power BI
    • Webinar
    • Courses
    • Login
  • Popular Videos

    • Dashboard Videos
    • Excel Chart Videos
    • Data Cleaning Videos
    • Pivot Table Videos
    • Lookup Formulas Videos
    • Excel Shortcut Videos

Copyright - Yoda Learning Solutions 2015-2020