Please note javascript is required for full website functionality.

Blog

Final Friday Fix: May 2022 Challenge

27 May 2022

We are all aware that Power Pivot works with the DAX (Data Analysis Expression) language. Power Pivot employs DAX for data modelling, and it is simple to use for self-service BI. Data tables and columns in data tables are the foundation of DAX. It's worth noting that it's not reliant on individual cells in the table like Excel's formulae and operations are. Data Analysis Expressions (DAX) may appear overwhelming at first, but the fundamentals of DAX are simple. However, as we continue to try to tackle ever more challenging challenges, we occasionally reach some hard boundaries.


Power BI Blog: Power BI Known Issues Page

26 May 2022

Welcome back to this week’s edition of the Power BI blog series. This week, we look at the newly launched Known Issues page.


Power Query: See it, Save it, Sort it - Part 2

25 May 2022

Welcome to our Power Query blog. This week, I continue looking at a sorting issue.


Power Pivot Principles: The A to Z of DAX Functions – COMBINEVALUES

24 May 2022

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


A to Z of Excel Functions: The MINIFS Function

23 May 2022

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


Charts and Dashboards: Data Tables - Part 1

20 May 2022

Welcome back to our Charts and Dashboards blog series. This week, we’ll cover the uses and types of Data Tables.


Power BI Blog: Locating Links

19 May 2022

Welcome back to this week’s edition of the Power BI blog series. This week, we look at how to view links in a webpage.


Power Query: See it, Save it, Sort it - Part 1

18 May 2022

Welcome to our Power Query blog. This week, I begin looking at a sorting issue, by initially considering Best Practice when extracting my data.


Power Pivot Principles: The A to Z of DAX Functions – COMBINA

17 May 2022

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


A to Z of Excel Functions: The MINA Function

16 May 2022

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


Newsletter