This month, our Final Friday Fix comes from a query that came in to us. So without further ado, let’s take a look!

Welcome to our new Power Query blog. Today I look at the relationship between Power Query and Power Pivot.

In probability theory and statistics, the binomial distribution with parameters n and p is the discrete probability distribution of the number of successes in a sequence of n independent success / failure experiments, each of which yields success with probability p. Almost the same as last time’s function, here at SumProduct, we like to demonstrate it’s not just TV companies that show repeats. ...

Every Friday, we intend to post a blog talking about VBA and highlight the benefits, the pitfalls, and cover a range of basic concepts that everyone who uses VBA should know.

Welcome our new Power Query blog. Today I extract information from a file name.

Almost the same as last time’s function, here at SumProduct, we like to demonstrate it’s not just TV companies that show repeats. Almost the same as last time’s function, here at SumProduct, we like to demonstrate it’s not just TV companies that show repeats. Almost the same as last time’s function, here at SumProduct, we like to demonstrate it’s not just TV companies that show repeats…

If you’ve never used macros but want to understand how they work, this series is for you...

Welcome to the very first post in our new Power BI blog series! Power BI is a tool produced by Microsoft that is designed to assist people with creating business intelligence solutions

Welcome our new Power Query blog. Today we unpivot data ready to append it to a query...

In probability theory and statistics, the binomial distribution with parameters n and p is the discrete probability distribution of the number of successes in a sequence of n independent success / failure experiments, each of which yields success with probability p.