Blog Posts

CALCULATE when possible


As you start getting more comfortable with DAX, you’ll quickly discover that there are multiple ways to skin a cat. In this quick tip, I’m going to try and explain how calculate with filtering works, and more generally, how to use calculate when possible. Let’s jump straight in with an example. What if you wanted to, for example, sum the amount of sales where the amount was greater than one? We could do something like this: Measure = SUMX (

Continue Reading

The DateTime Data Type – Power BI Quick Tips

datetime data type

I thought I’d put together a short series of posts with some quick and simple tips that we can all adhere to. The aim is to help us improve our DAX queries and the general speed of our Power BI and/or SSAS tabular models. In this first tip, I’d like to talk about the use of the datetime data type in your tabular and Power BI models. Before we get to the tip itself, I’d like to talk about how

Continue Reading

Power BI Security FAQs

I often get asked questions about Power BI and security. Microsoft do provide a detailed security whitepaper which can be downloaded from the Microsoft Trust Center with other information relating to security. I would strongly recommend reading the whitepaper if you have security concerns. With that said, I wanted to offer something a little less wordy. Something that got to the point and answered the various common questions in simple English. I don’t work for Microsoft and I don’t offer any guarantees to

Continue Reading

Reverse engineering summarised data using DAX

Those who use Power BI, Analysis Services, or any other data modelling tool that uses DAX, will know that most of the time you will be taking very detailed data and in one way or another turning it into useful summarised data, as such is why we use reporting or dashboarding tools. The problem In most cases the source data you will have is relatively detailed, making it easy to create a data set that can be sliced by a particular data

Continue Reading

Quickly and Easily Create Permission Sets in NAV 2016

Anyone who is familiar with Microsoft Dynamics NAV will know that when it comes to managing permissions, it can almost be a full time job during the initial implementation of your system. Unless your using the “out-of-the-box” permission sets provided by Microsoft, the creation of new permission sets and adding all the associated tables and permission levels is a painfully laborious process. With the recent release of NAV 2016, Microsoft have introduced a new feature, with little little to no

Continue Reading

Taking back your email

The last year has been crazy when it comes to discussion around online privacy and government monitoring. It doesn’t end there either. The discussion that has been ignited also raises questions about the various online services we use and the data we entrust in companies like Google, Facebook, and Apple. Savvy Internet users are becoming more aware about the personal information they post online for fear of who can see that information, and what the companies do with that information

Continue Reading

Site Footer