If you already know pivot tables in excel then it is easy for your to learn Power BI. Check out with a simple example how we use pivot table to create a summary and the same which can be created in Power BI. The best way to learn Power BI is to convert all your existing reports into Power Query and DAX formulas and visualize it in Power BI.

Lets see the basics of Power BI. We will see how to load a simple excel table into Power BI and convert it to a basic chart. It is important to experience first hand how to load the data and see various options of visuals.

Lets see now how we quickly add a column and how to add a measure in Power BI. And also how to use it.

Not every time we have a table that starts from top row. Sometimes top 2 or 3 rows have just details about the table. Thus its required to skip these additional rows. We will see here how to do that while loading the data and transforming it accordingly.

If you would like to compare revenue/expense or any metrics of the current month with prior month then this video is for you. Here we will create measures for current month and previous month to allow us to use them in a visual of your choice. Comparison can be done with prior month, quarter or an year.

You might have worked with conditional formatting in Excel. Now lets see how it works in Power BI. Its very similar to that in excel.

Average in general is a straight forward formula but if you want to have a weighted average then you will have to do it a bit differently. Here in this video we will see how weighted average works in excel and how can we have something similar in Power BI.

We use SumX in Power BI to get through the problem of weighted average. Lets see how we make weighted averages in excel and then using SumX Formula how do we have the same solution in Power BI.

​