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

Welcome back to our Charts and Dashboards blog series. This week, we continue to show you how to make a bespoke Horizontal Raincloud chart, by merging the charts created so far to create the final Horizontal Raincloud chart.

Welcome back to this week’s edition of the Power BI blog series. This week, we look at how to create calculation groups using the Model explorer now in Preview.

Welcome to our Power Query blog. I would like to get a list of all the Power Query blogs I have posted. Today, I begin by extracting data from the first page.

In our long-established Power Pivot Principles articles, we continue our series on the A to Z of Data Analysis eXpression (DAX) functions. This week, we look at FIRSTDATE.

On the final Friday of each month, we set an Excel / Power Pivot / Power Query / Power BI problem for you to puzzle over for the weekend. On the Monday, we publish a solution. If you think there is an alternative answer, feel free to email us. We’ll feel free to ignore you.

On the final Friday of each month, we set an Excel / Power Pivot / Power Query / Power BI problem for you to puzzle over for the weekend. On the Monday, we publish a solution. If you think there is an alternative answer, feel free to email us. We’ll feel free to ignore you.

Welcome back to this week’s edition of the Power BI blog series. This week, we provide you with some relationship advice free of charge...

Welcome to our Power Query blog. Today, I look at the reason behind an issue I encountered recently when importing Excel files from a folder.

In our long-established Power Pivot Principles articles, we continue our series on the A to Z of Data Analysis eXpression (DAX) functions. This week, we look at FIND.