Last week we used the LookAt parameter with the Find method to match the complete word. This week we look at case.

Welcome back to Power BI Tips! This week, we begin Just Speculating Over the NY Powerball numbers.

Welcome to our Power Query blog. This week, I look at some useful Boolean Text() functions in M.

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.