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.

This function converts a binary number (base two) to an octal number (base eight)...

Welcome our new Power Query blog. Today we extract multiple files from a folder...

Welcome again to 2017! Last week, at the end of December, we asked if you could create a chart that would have the number format of the chart axis dynamically change when the values being charted increase or decrease.

Wherever you are in the world, all of us here at SumProduct would like to extend the season’s greetings to you, wherever you may be. We hope you have an EXCELlent time and a prosperous New Year.