Power BI – What If parameters

Posted by on Aug 11, 2017 in DAX, Power BI | No Comments

The latest release of Power BI Desktop (August 2017) contains a pretty cool feature that was teased back in the keynote of the Microsoft Data Insights Summit which is the ability to add What If parameters to your data model. To add a What If parameter, just click New Parameter on the the Modeling tab which ...

Read More

Measure table madness

Posted by on Jul 27, 2017 in Power BI | 2 Comments

Measure tables in Power BI models are a fantastic way to group your calculated measures together in one place and make for a tidy model. Unlike calculated columns, a calculated measure can be placed on any table so long as the best practice of using the table name for every column reference. Power BI desktop ...

Read More

2017 Data Insights Summit – Key Note (Live)

Posted by on Jun 13, 2017 in Uncategorized | No Comments

Not just one but TWO live blogs from Radacad running so you won’t miss anything! Reza is also blogging here http://radacad.com/microsoft-data-insight-summit-2017-keynote-live-blog 5 mins to go. Sitting between Chris and Alberto. We are delayed due to the massive influx of attendees queuing to get in. James Phillips speaking now Summit sold out 5 weeks early 2500 ...

Read More

Optimising Power BI data models

Posted by on Jun 3, 2017 in ETL, Power BI, Uncategorized | 8 Comments

For this blog I thought I would share a handy trick for optimising Power BI using a data modelling solution that is often forgotten or overlooked.  It involves focusing on certain columns based on the degree of uniqueness they contain and converting or removing all together from a data model.  I will explain how and why this ...

Read More

Dynamic distances in Power BI

Posted by on Jun 3, 2017 in DAX, Power BI | One Comment

I recently encountered a question posed to the Power BI community forum I found interesting enough to kick-start my blogging on Power BI. The essence of the question was asking how to dynamically determine distances between two geographic points from user based selections.  So I thought I would cover how this can be done in Power BI to ...

Read More