Welcome back to our Power Pivot blog. Today we discuss negating formulas in Power Pivot.

Depreciation is a method of allocating costs over the useful economic life of an asset (e.g. a building, a car, a computer). This function returns the depreciation of an asset for a specified period using what is known as the fixed-declining balance method (explained below).

Last week we looked at using the After, SearchDirection and SearchOrder parameters of the Find method.

Last week we finished creating our queries and got our Powerball data together. Let’s have a look at the field pane to see what tables are available to use.

Welcome to our Power Query blog. This week, I look at an example where data comes in one Excel column and needs to be converted to a table.

Can we use more than one criteria with the CALCULATE function?

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 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’s no prizes at this stage, you’re playing for bragging rights only!

Last week, we successfully extracted the names of the columns from the metadata of the JSON file. Now it’s time to put the two queries together!

Welcome to our Power Query blog. This week, I look at splitting data using a variety of delimiters.