On 23 May 2024, I had the pleasure of presenting a session titled Dissecting Field Parameters to Power BI Barcelona User Group. Thank you Bernat Agulló for inviting me! In this post I wanted to post a quickfire list of the key points I presented! 😊 The PBIX containing the examples is here: 1. Simplest…
If you have ever created a Power BI report with live connection to an Analysis Services Tabular model (SQL Server Analysis Services or Azure Analysis Services), you might have wondered if it is possible to use field parameters in such a report. The answer is yes! The main point to remember is that field parameters…
Have you ever wanted a slicer or filter in your Power BI report to select the most recent date by default (or something similar) when it is opened? In my experience this is quite a common request, and in this post I’ll share some solutions I’ve been experimenting with. Isn’t this already on Microsoft’s roadmap?…
Introduction In my previous post Creating alias columns for calculation groups I showed how to create alias columns containing alternate names for calculation items in a calculation group by using the Group By Columns property. To recap: By setting the Group By Columns property of any alias columns to be the original calculation item column,…
Quick Summary Introduction The purpose of this post is to show how to add an “alias column” to a calculation group, containing alternate names for calculation items but functioning in the same way as the original calculation item column (the column containing the names of the calculation items). To begin with, did you know you…
Suppose we have a number of investment portfolios managed by separate managers, that each start with $100 on 1/1/2015, earn a random return each day, and receive external cash flows on certain days (for the sake of an example, an inflow of $10 at the end of every Monday). We would like to measure the…
Hi, I’m Owen Auger, and welcome to my blog at owenaugerbi.com! I made a start at blogging on Power BI a few years back on a free site, but have decided that it’s time to move to my own domain, so now I’m rebooting here. For my first couple of posts, I am going to…
