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

Welcome back to our regular A to Z of Excel Functions blog. Today we look at the PERCENTRANK.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 all the data we have summary, prepare and transform to plot the chart.

Welcome back to this week’s edition of the Power BI blog series. This week, we look at a new DAX function available in Power BI: MATCHBY.

Welcome to our Power Query blog. Today, I look at the functionality available in Power Query Online, available during dataflow creation in Power Apps.

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

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 continue to explain how to create a bespoke Point and Figure chart by looking at how we use the prepare data to transform the chart data.

Welcome back to this week’s edition of the Power BI blog series. This week, we look at the wonderful world of Power BI Desktop, OneDrive and SharePoint.

Welcome to our Power Query blog. Today, I take a sneak peek at a feature that is currently only available on the ‘Office Insider’ program.