Please note javascript is required for full website functionality.

Blog

Power Pivot Principles: Tips on Calculated Columns

16 October 2018

Welcome back to our Power Pivot blog. Today, we discuss some tips and best practices you should keep in mind when working with Calculated columns.


A to Z of Excel Functions: The DSTDEV Function

15 October 2018

Welcome back to our regular A to Z of Excel Functions blog. Today we look at the DSTDEV function.


VBA Blogs: Going Through the Visual Basics – Part 9

12 October 2018

We thought we’d run an elementary series going through the rudiments of Visual Basic for Applications (VBA) as a springboard for newer users. This blog looks at the concept of a variable scope at a project level.


Power BI Blog: Visiting Ideas 2 – DAX editor

11 October 2018

October is Ideas month for our Power BI blog!


Power Query: Group Dynamics

10 October 2018

Welcome to our Power Query blog. This week, I look at how to calculate a group share.


Power Pivot Principles: Importance of Contiguous Dates

9 October 2018

Welcome back to our Power Pivot blog. Today, we discuss why it is important to have Contiguous Dates in a calendar table.


A to Z of Excel Functions: The DPRODUCT Function

8 October 2018

Welcome back to our regular A to Z of Excel Functions blog. Today we look at the DPRODUCT function.


VBA Blogs: Going Through the Visual Basics – Part 8

5 October 2018

We thought we’d run an elementary series going through the rudiments of Visual Basic for Applications (VBA) as a springboard for newer users. This blog looks at the concept of a variable scope at a module level.


Power BI Blog: Visting Ideas

4 October 2018

Last week, we had a training session where someone suggested a great idea for an improvement to Power BI. That gave us a great idea – October is going to be Ideas month for our Power BI blog!


Power Query: Let It Be

3 October 2018

Welcome to our Power Query blog. This week, I look at (some of the most) simple M statements.


Newsletter