Related and RelatedTable – DAX for Power Pivot, Power BI and SSAS

When we looked at the SUM and SUMX expressions in an earlier article and video we introduced the use of RELATED. You will remember this expression; =[Qty] * RELATED(products[Sales Price]) Where we took the qty sold from the sales table and we went across to the related products table and found the relevant sales price […]

Resolve Errors in Excel Formula

How to Resolve Errors in Excel Formula

It is not uncommon to encounter errors in spreadsheets.  But thankfully Microsoft has equipped Excel with tools to help resolve errors in Excel formula.  This include the ability to evaluate formula and set error checking options. In this article we will cover step by step the options available to help resolve errors in Excel formula. […]

Step by Step – Named Ranges in Excel

Before we really get stuck into this article please go ahead and download the workbooks so that you can practice along step by step. There is no email or sign up to download the files.  This training is free for all and the best way to learn Excel is to practice along. Wanna learn more […]

Up and Running with Excel Form Controls

An Excel form control is a kind of user interface component that can be added to a worksheet. You can add a single form control to a worksheet, or a group of form controls. Some of the form controls that you can choose from include list boxes, check boxes, radio buttons, scroll bars, combo boxes, and […]

DAX COUNT and COUNTX – Impact of Using Measures and Columns

In a previous post we looked at DAX SUM and SUMX  expressions and you were introduced to a lot.  We mentioned table functions, iterators, row and filter context, measure, columns, and we also quickly introduced you to the RELATE function. In this article we are going to slow things down a little and look at DAX […]

Find Hard coded values in Excel Formulas

Find Hard coded values in Excel Formulas

Finding hard coded values within Excel Formulas is something Excel users have struggled with for a long time. While I was researching this article, I am surprised that the solution I am about to offer you has not been widely covered so far. What exactly is a hard coded value? It would be common to […]

What is DAX

What is DAX (DATA ANALYSIS EXPRESSIONS)

Data Analysis Expression language or DAX, was originally released with Power Pivot in Excel in 2010 by Microsoft. It’s a functional language that is very similar to excel, as you would expect as it was part of the excel tools.  Its initial basic function was to allow excel users solve more complex business problems. Now, […]

Document Entire Excel Workbook with the Click of a Button

Document Entire Excel Workbook with the Click of a Button

Why Document an Entire Excel Workbook You already know the story…. or do you…..? So the internal accountant produces a monthly pack for management, which contains financial information. These reports are fantastic.  Detailed Sales reports show sales against budget, against prior year, as a 12 month rolling total. They are also further sliced against sales […]

Decoding M – Exploring the YouTube Data API with Power BI

For some time now I have wanted to explore connecting Power BI with API’s, however the lack of knowledge of M, and time has held me back. But this week I got a chance to dig a little deeper with my idea. I decided to look at Google’s YouTube Data API.  First I just want […]