Please note javascript is required for full website functionality.

Blog

Power BI Blog: Text isn't Limiting! - Part 5

5 April 2018

Last week using the US Historical Population Estimates we created our first DAX formula. Now we have categorised our data by decade, how can we focus the view on a specific decade?


Power Query: Zipping Through a List

4 April 2018

I have been looking at List functions in M language recently, and this one reminds me of my problems with null values in lists...


Power Pivot Principles: Tables, Fields and Measures

3 April 2018

Today let’s go over the syntax between a table, a field, and a measure.


Monday Morning Mulling: March 2018

2 April 2018

On the last Friday of each month we set an Excel puzzle for you to puzzle over the weekend. On the Monday, we publish a solution..


A to Z of Excel Functions: The DATE Function

2 April 2018

This function returns the sequential serial number that represents a particular date...


Poisson D'Avril

1 April 2018

Happy April's Fool Day! In France, it's called Poisson D'Avril and in honour we've released a new thought article.


Final Friday Fix: March Challenge 2018

30 March 2018

It’s that time again, the long weekend! That should give you plenty of time to solve our Final Friday Fix!


A to Z of Excel Functions: The CUMPRINC Function

30 March 2018

This function returns the cumulative principal repaid on a loan between a designated start_period and end_period given a constant periodic discount rate...


Power BI Blog: Text isn't Limiting! - Part 4

29 March 2018

The fourth part in our series involving the US Historical Population Estimates data set. Using DAX to create a calculated column.


Power Query: Seeded Accommodating Accumulating

28 March 2018

This week, I look at the M function List.Accumulate and its uses where the seed is not zero.


Newsletter