Welcome to our Power Query blog. Following on from last week’s blog, this week I look at some useful extraction Text() functions in M.

Welcome back to our Power Pivot blog. Today we discuss how to use the ALLEXCEPT function in DAX.

This function converts a decimal number (base 10) to hexadecimal (base 16).

It’s easy enough to get on a cell’s case as we explored last week, but what if we wanted to find a cell that is formatted in a particular way?

Using the Power Query editor to determine unique combinations from the NY Powerball data.

Welcome to our Power Query blog. Following on from last week’s blog, this time I look at some useful transforming Text() functions in M.

Welcome back to our Power Pivot blog. Today we discuss how to use the ALL function in DAX.

This function converts a decimal number (base 10) to binary (base two).

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.