Power BI

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…

I use Sales data a lot in my tutorials and usually the Sales Fact table will have the following fields in it: DateProductRevenueUnits Along with a bunch of other stuff…. Now, it is actually very co…

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…

Unfortunately, life is hard and in BI world we are guaranteed to fail with our Data Persuasion every now and then. Having failed with my BI presentations many a time, I decided to write this articl…

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

Power BI is the Magic Quadrant Leader among analytics and business intelligence platforms and over 200,000 customers around the world use Power BI and bring 40 petabytes of data into Power BI every …

We’re pleased to share that we are now previewing step folding indicators in Power Query Online. These indicators will allow you to understand which steps fold, and which steps don’t. Read on for more.

Before digging into this, let’s be clear about 1 thing. When Power BI Premium Per User (PPU for short) and Power BI Premium v2 were announced at Ignite 2020, the collective user base of Power BI …