greggyb's blog
I am Greg, or greggyb in as many places online as I can be. This is my blog. Sometimes I post here.
I work on simplifying Power BI operations at Argus PBI and improving developer experience at Tabular Editor. If you want to, you can read more about me, here, but I have to warn you that I do not have much to say on the topic.
Find me
Socially
Elswhere
- Microsoft Fabric Community Summit: 2024-03-24--2024-03-28; Las Vegas, NV
And in the past
- Community Summit: 2023-10-15--2023-10-20; Charlotte, NC
- Power BI Next Step: 2023-09-21--2023-09-22; Copenhagen
- Beyond the GUI: Power Query and M techniques
- Power BI Guy livestream: 2023-07-27 15:00-4
You can find a comprehensive list of me at places other than here on my About page.
Here are some recent posts
Advancing Power BI and Tabular
Wednesday 2024-01-17
New year, new blog post, lotsa new! In the last year, as seems normal now, most of my writing remained code and conference presentations. We launched Argus PBI. I worked on some very cool data models. Oh, and I started working at Tabular Editor , too!
Monday 2022-12-12
For a fun challenge, and hopefully to prompt a slightly better cadence of writing, I am doing this year's Advent of Code in Power BI. If you are not familiar with Advent of Code, it is an annual series of programming challenges, one per day of December leading up to Christmas. It is a great opportunity to practice a programming language with small, self-contained problems of increasing difficulty. Power BI is probably not a great fit for some of the algorithmic challenges that are likely to appear in later days, but I want to take it as far as I can. I will be updating this post in place as I go, with brief notes on each day's challenge. All code can be found in the companion pbix (week 2), with comments to explain my approach. I will not give full write-ups of each solution in this post, but encourage you to follow along in that PBIX as I update it, or better yet, by trying out the challenges on your own!
On DAX's difficulty and CALCULATE: a rant
Thursday 2022-11-03
Why is DAX so hard to learn? It is an evergreen topic. DAX is difficult to learn because of its inherent complexity. DAX is presented as difficult to learn in ways that do not align with this complexity. The topic is evergreen because of demography among DAXists. This difficulty has spawned a movement, for lack of a better term, rebelling against
CALCULATE
and purporting to improve the experience of writing DAX by writing it worse. In this post, I will explore these topics and share some opinions on the same.DAX column types on PowerBI.tips
Tuesday 2021-12-07
I've just published a post exploring the nuances of data types in columns in DAX. (Archive.) This reveals some unexpected behavior in projected columns in a DAX expression. See the post on Power BI Tips for all the gory details (and a bonus pattern for dynamic ranking and aggregation as the worked example).
Understanding filter context as sets of values
Friday 2019-10-11
I recently came across a real head-scratcher of a question on Stack Overflow. This post is an expansion of the answer I gave there. The goal is to provide a useful model to understand filter context. This is foundational knowledge for any aspiring DAXter (DAXist?) and is required to understand
CALCULATE
properly.