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 EFFECT.

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

Welcome back to our Charts and Dashboards blog series. This week, we continue to explain how to create a bespoke Point and Figure chart by looking at how we use the summary data to prepare the chart data.

Welcome back to this week’s edition of the Power BI blog series. This week, we look at the Optimize tab on the Ribbon.

Welcome to our Power Query blog. This week, I create a query by extracting rows in Data that have no matches in Country.

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 EDATE.

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

Welcome back to our Charts and Dashboards blog series. This week, we’re going to look at how to make a bespoke Point and Figure chart.

Welcome back to this week’s edition of the Power BI blog series. This week, we inspect two new DAX functions, RANK and ROWNUMBER.

Welcome to our Power Query blog. This week, I solve the formatting issue in my merged query and apply some buffering.