Power BI

Want to improve the performance and design of your Power BI model? Run these newly published rules against your model to quickly identify areas of improvement!

One of the most exciting things about being a Power BI service administrator is watching what's going on inside the service. This blog starts a series of articles on how to create your own Service Monitoring application using Power BI.

I tend to create tables using M or a combination of point-and-click and M, because these tables are treated as base tables if the model is refreshed and for this reason these tables will benefit from all the compression magic, whereas tables created using DAX are not that well compressed.

Query folding is a key capability in Power Query. In short, query folding is the process by which the Power Query mashup engine takes the steps defined in the Power Query editor and translates them…

This article shows an optimized DAX technique to display the first N products for each category in Power BI, adding a row that aggregates the value for all

This article describes the syntax and the use cases of the DEFINE COLUMN statement in DAX. Introduced in December 2020, the DEFINE COLUMN statement lets you

How many times did you ask a technical question, to be met with a laconic “it depends”? Or worse, for your question to be totally ignored? This is so ty

“DirectQuery for Power BI datasets and Analysis Services” is the name of a new feature released in December 2020 that we simply call… R

This article describes the syntax and the use cases of the DEFINE TABLE statement in DAX. Introduced in December 2020, the DEFINE TABLE statement lets you d

I found this interesting chart on Datawrapper.de and it made me think about how (and whether) my chart selections also changed over time. (Datawrapper is a pretty cool tool that allows users to upl…

If you are looking to challenge your DAX skills while trying to figure out how to calculate a Cumulative Discount (or a Cumulative Commission) then this tutorial is for you. A Cumulative discount i…

This blog post details how to create the default format string with calculation groups when no items are selected in Power BI

This blog post demonstrates how to use the new DirectQuery (Composite) models in Power BI and then connect it with a local Excel file.

Last December, I teamed up with my brother (who runs Daily Cookie, an email marketing boutique) to deliver the best-of-breed Power BI app for email marketing. DataChant and Daily Cookie proudly present the ActiveCampaign Email Marketing app. The app is available to download on Microsoft AppSource for free here. If you don't have a Power…

I’m joining Adam Saxton on the famous Saturday morning Guy In A Cube live stream! We’re going to chat a bit about the newly updated Power BI End-To-End diagram , as well as what the top few challenges are when governing Power BI. And we’ll tackle questions from the audience.

AI Insights in Power Query is a great Premium feature in Power BI. AI Insights Error can occur if you are not fully aware of the settings.

With this conditional formatting technique, you can show your users a message on the visual (using text or images) instead of a blank visual.

Interested in learning how to compare certain budgeted scenarios vs. actuals? In this blog post, I will demonstrate a technique to show you how to do that.

[vc_row][vc_column width="1/1"][vc_single_image media="88035" media_width_percent="100"][vc_column_text]Watch the video above to learn how to set up a visual with a dynamic date axis […]

Why Microsoft 365 adoption projects fail - a deeper look into corporate mental models, organizational structures, and patterns in working behavior