Welcome back to our Power Pivot blog series. Today we discuss a function that we can use in developing measures.

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

Last week we ran into the SearchOrder parameter of the Find function. We knew that we could go right across the row or down the column. But what if we wanted to manipulate the direction of which we searched? Instead of going down the columns using xlByColumns what if we wanted to go up?

Remember last week we brought in our JSON file and focused on transforming and preparing the dataset portion. This time, we’re going to retrieve the column names from the metadata.

Welcome to our Power Query blog. This week, I look at a more comprehensive method to convert a check box into a name.

After importing data into Power Pivot, we may wish to create a PivotTable.

Today we look at the DCOUNT function. This function counts the cells that contain numbers [not text which looks like numbers] in a field (that’s jargon for a column!) of records in a list or table that match one or more conditions you specify.

Last week we set the After parameter for the Find method to distinguish which cell we wanted to start from. But it defaulted to go across the row. It can be set in order to go down the columns first using the SearchOrder parameter.

Power BI exercise focusing on JSON files using the NY Powerball data.

This week, I look at a simple method to convert a check box into a name (next time I will move up a gear!).