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.

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.

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

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.

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

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.

October is Ideas month for our Power BI blog!

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

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

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