DAX SUM and SUMX functions

DAX SUM and SUMX Functions

The role of both DAX SUM and SUMX functions is to add numerical data together. Yet both these functions are rather different. Let’s talk about the SUM function first. The SUM function is simple. It takes a column of data and adds the values to give a total. It works like the sum function in […]

How to Parse Custom JSON Data using Excel

How to Parse Custom JSON Data using Excel

To Parse Custom JSON data is to split out its name/value pairs into a more readable useable format. Excel is a powerful tool that allows you to connect to JSON data and read it.  However sometimes this data might require a little manipulation to be fully understood and analysed in Excel.  In this article you […]

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 […]

Excel pimped with power

Excel Pimped with Power Tools

Excel is one of those tools that you just can’t live without.  It is used to store information, run calculations, carry out analysis, prepare report, visualizations and much more.  What’s just as important is the flexibility it gives to its +750 millions of users. This flexibility allows users create their own calculations and analysis, in […]

Excel Power Trick – How to Combine a Folder of CSV Files

I previously published an article and video ‘Excel Power Trick – Save time without VBA’ which seems to have been very popular.  In this video we looked at using Power Query to get data from Excel sheets, format that data and then save the query for future use.  It’s amazing how much time you can […]

many to many relationships power pivot

Easy Excel Solutions: Power Pivot Many to Many Relationships

Learn How to Manage Many to Many Relationships in Power Pivot Power Pivot has been around since 2010, and many people still struggle with managing relationships.  Even more so most struggle with more complex relationships such as Many to Many relationships.  In fact, I have seen many people begin to set up data models in […]

Excel Power Trick – Save Time Without VBA

In the video below you will learn an Excel Power Trick, using Excels Power Query,  to transform standard Excel data.  This trick promises to save you time month after month. If you are new to Excels Power Tools (Power Pivot, Power Query and Power View), after you finished this example, you should really take a […]