This PowerBI free online training video will show you through how to display totals for the financial year and display them on a line graph.
Free tutorial showing how to create RAG KPI icons. We did this in an early video but since then Microsoft have added icons to conditional formatting.
See how you can calculate and display the difference from the Average Mean of sample data in an Evaluation context and Average Mean of the Total range of data.
Get your data from Microsoft Access into Power BI. This way you can reap all the benefits that Power BI gives. Use this free online Power BI training tutorial to help you avoid problems.
Power BI is a big animal. So when you look at your humble spreadsheet you may ask yourself what you need to do to get the data into Power BI. Although this tutorial is one of our longer free online Power BI training sessions, However this is really a must, if you want to get started with the online version of Power BI. You will need a Microsoft Account and have logged in to Power BI before following this video.
Find out how to create the traffic light RAG (Red,Amber,Green) status icons in a table within Power BI.
This tutorial will show you how to group values using Power BI. This guide shows you on how to use DAX and in particular the CALCULATE function to group values.
What can you get out of Date Tables? Surely you've got dates in your main "fact" table so why should you need to add another table? This video tutorial will show you how to create a date table, integrate it with your data model along with a couple of handy fiscal calculations.
This tutorial will show you how to sort by month in Power BI. Understanding the fundamentals with regard to sorting by month can help open the door to many other sorting options in Power BI.
Use the DATEADD function to look at the previous year. Then go further and work out the percentage difference between this year and last year.
Find out how to create a DAX formula to work out year to date with the DATESYTD function in Power BI. This short tutorial will take you step by step.
Now you've discovered how to work out year to date what about year to date for the previous year? This short tutorial will show you how.
This tutorial will show you how to create a DAX formula in Power BI for cumulative totals specifically for financial accounts of 4 week periods.
You know of Power BI. But to use you'll need to install. It's good to know if you have the 32 or 64bit version of office installed before you start. This short video will show you what to do.
If you're having trouble connecting to an acccess database then you might want to check out this Power BI free online training video.