Search Results

Get started with Power BI now by creating your first dashboard. Download the free files, follow along and in 20 minutes you’ll have setup your interactive dashboard which you’ve published to the web!

If you’d like to “see” how the DAX CALCULATE function works, then you need this tutorial. It will show you how the CALCULATE function works and delivers results.

These 3 hidden Excel Power Pivot tips will help you to: Copy your data model from one file to another, create a dedicated measures table and convert your pivot table data to formulas.

Learn how to easily create a forecast in Excel – even if you have seasonality. It just takes one click and Excel can forecast the next months for you!

Learn how to use the new Excel SCAN function! This function is a Lambda helper function. You can use it to “scan” a range and apply a calculation to each cell. In this example you’ll learn how to use SCAN to get to-date values and how you can tweak it to return YTD values.

Learn the meaning of percentile in introductory statistics and how to calculate Percentile in Excel. There are two functions one is PERCENTILE.INC and the other PERCENTILE.EXC. I’ll explain the difference and also how you can calculate PERCENTRANK in Excel.

Here’s why you should upgrade to Office 2021 if you’re on 2019 or 2016 (and for some reason you can’t upgrade to 365). You get life-changing Excel functions like XLOOKUP, UNIQUE, FILTER, SORT and a lot more. I cover what you get when you upgrade in this post.

With this trick you can easily combine and repeat blocks of values together in Excel. You don’t need copy pasting or complicated formulas. Just a tiny bit of Power Query. This keeps your solution dynamic too.

It’s super easy to setup an automation in Power Automate to get notified when someone submits their answers in a Microsoft Form. You can also add a condition, so you get an email or mobile notification only when a specific answer is submitted.

Find out how you can use the new Excel BYROW and BYCOL functions. These are called Lambda helper functions and they can help you save a lot of time if your analysis is based on a whole row or an entire column. Check out this practical example to find out more.

With Pivot Charts in Microsoft Excel, you can add slicers to add interactive functionality to your dashboards. But what about adding even more interactivity? You could give the user the ability to change the relevant KPI in the chart from the slicer. You just need a tiny bit of DAX.

You can easily add text to your cell values in Excel. You don’t have to do this manually. You have 3 easy options to choose from. The 3rd one will surprise you. You can use it in many other circumstances as well.