Please note javascript is required for full website functionality.

Blog

Final Friday Fix: February 2025 Challenge

28 February 2025

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.


Power BI Blog: Semantic Model Version History in Preview

27 February 2025

Welcome back to this week’s edition of the Power BI blog series. This week, review the semantic model version history, currently in public Preview.


Power Query: A Tangled Web Part 1

26 February 2025

Welcome to our Power Query blog. This week, I use the ‘Add Table Using Examples’ functionality to create custom tables from web data.


Power Pivot Principles: The A to Z of DAX Functions – INFO.RELATEDCOLUMNDETAILS

25 February 2025

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 INFO.RELATEDCOLUMNDETAILS.


A to Z of Excel Functions: The RSQ Function

24 February 2025

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


AI Blog: Copilot Tour Part 1

21 February 2025

Welcome back to our AI blog. Today, we’ll take a look at some of the features available in the free version of Copilot.


Power BI Blog: Explore This Data from a Visual

20 February 2025

Welcome back to this week’s edition of the Power BI blog series. This week, we look at an alternative way new to Power BI that you may “explore your data”.


Power Query: Making Your Mark(up) Part 6

19 February 2025

Welcome to our Power Query blog. This week, I extract the data from the DNARecord query created when I extracted an XML file from the web.


Power Pivot Principles: The A to Z of DAX Functions – INFO.REFRESHPOLICIES

18 February 2025

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 INFO.REFRESHPOLICIES.


A to Z of Excel Functions: The RRI Function

17 February 2025

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


Newsletter