Please note javascript is required for full website functionality.

Blog

Power Pivot Principles: Perspectives

23 October 2018

Welcome back to our Power Pivot blog. Today, we discuss how to create and use Perspectives in PowerPivot.


A to Z of Excel Functions: The DSTDEVP Function

22 October 2018

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


VBA Blogs: Going Through the Visual Basics – Part 10

19 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 declaring constants.


Power BI Blog: Visiting Ideas 3 – Custom Visuals template

18 October 2018

October is Ideas month for our Power BI blog! If you haven’t been there yet, go check out ideas.powerbi.com. This is essentially the suggestion box for Power BI, where users can submit great ideas that they’d like to see and vote on other ideas that they agree with.


Power Query: Mind the Gap

17 October 2018

Welcome to our Power Query blog. This week, I look at how to fill in rows when there is a gap in dates.


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.


Newsletter