Welcome back to the Power Pivot Principles blog. This week, we will compare the HASONEFILTER function to the HASONEVALUE and ISFILTERED functions in DAX.

Welcome back to this week’s Charts and Dashboards blog series. This week, let’s continue our consideration of Form Controls. Here, we look at how to create a Drop-down List using them.

Welcome back to this week’s edition of the Power BI blog series. This week, we look at how to import fonts into Power BI.

Welcome to our Power Query blog. This week, I look at replacing values in all columns in a table.

Welcome back to the Power Pivot Principles blog. This week, we will talk about the HASONEFILTER function in DAX.

On the final Friday of each month, we set an Excel 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’re going to set an Excel / Power BI challenge for you to puzzle over so that you can get your “Excel fix”. Challenge your office colleagues to see who can solve the puzzle quickest. There are no prizes at this stage: you’re playing for bragging rights only!

Welcome back to this week’s edition of the Power BI blog series. This week, we look at how to deal with missing columns.

Welcome to our Power Query blog. This week, I look at transposing versus unpivoting data.

Welcome back to the Power Pivot Principles blog. This week, we will talk about the difference between the ISCROSSFILTERED and the ISFILTERED functions in DAX.