How To Series

Using the VLOOKUP Function

About this tutorial A part of our Excel series where we explain various concepts relating to analysing data in Excel. In this video, we discuss using the VLOOKUP function. Link to Dataset: https://bit.ly/2DH6dhW Other Excel series videos Absolute, Relative and Cell Referencing Related article > How to design an Expenses Management Dashboard in Excel Previous […]

Excel – Absolute, Relative and Cell Referencing

About this tutorial The first in our Excel series where we explain various concepts relating to analysing data in Excel. In this video, we start by going over referencing in Excel – we discuss, Absolute, Relative and Cell Referencing. Link to Dataset: https://bit.ly/3fuetQe Other Excel series videos Using the VLOOKUP Function Related article > How […]

Using The PARALLEL PERIOD Function

About this tutorial Time intelligence adds extra dynamics to our report. In Power BI, there are several in-built time intelligent functions. In this video, we discuss; PARALLEL PERIOD Link to dataset: bit.ly/2X1PzRg Other DAX series videos How to create a calculated column How to create a conditional calculated column How to Calculate Percentage of Total […]

About this tutorial Time intelligence adds extra dynamics to our report. In Power BI, there are several in-built time intelligent functions. In this video, we discuss; DATEADD Link to dataset: bit.ly/2X1PzRg Other DAX series videos How to create a calculated column How to create a conditional calculated column How to Calculate Percentage of Total How […]

How to Calculate Month-to-Date, Quarter-to-Date, Year-to-Date Values

About this tutorial Time intelligence adds extra dynamics to our report. In Power BI, there are several in-built time intelligent functions. In this video, we discuss; TOTALMTD, TOTALQTD and TOTALYTD. Link to dataset: bit.ly/2X1PzRg Other DAX series videos How to create a calculated column How to create a conditional calculated column How to Calculate Percentage […]

How to Calculate Value of Previous Quarter

About this tutorial Time intelligence adds extra dynamics to our report. In Power BI, there are several in-built time intelligent functions. In this video, we discuss the PREVIOUS QUARTER value. Link to dataset: bit.ly/2X1PzRg Other DAX series videos How to create a calculated column How to create a conditional calculated column How to Calculate Percentage […]

How to Sort a Table Visual

About this tutorial This video teaches you how to sort table visuals flexibly to meet your specific requirements. Other DATA VIZ series videos How to: lorem ipsum laserrt Related article > How to design an Expenses Management Dashboard in Excel Previous tutorial > Building Nigeria Fuel Prices Dashboard in Power BI Subscribe to our latest […]

How to Calculate Percentage of Change between Values

About this tutorial In building reports, you may want to show the percentage change between values. Also, you may run into some unwanted values in your calculation. This video shows you how to calculate for the percentage of change between values and also handle unwanted values should you run into any. Other DAX series videos […]

How to Extract Previous Day & Previous Month Values

About this tutorial Time intelligence adds extra dynamics to our report. In Power BI, there are several in-built time intelligent functions. In this video, we discuss two of such; PREVIOUS DAY & PREVIOUS MONTH. This is the first of a multi-part series on time intelligence functions in Power BI. Other DAX series videos How to […]

How to Count Rows in Power Query

About this tutorial In this video, We will show you three methods of counting the number of rows in a table within Power Query. We’ll also discuss and show you the advantages and disadvantages of using the various methods – Table.RowCount and List.Count Other Power Query Series videos How to Create a Date Table in […]