Best practices are wonderful things when understood properly. However, best practices can be terrible things if you don't fully understand the rational behind them or their nuances.

Your DAX calculated columns aren't the end of the world...

What new functions added in DAX during 2022

Query Folding are fundamental for an efficient ETL and while working with Power Query Editor you must push the steps that breaks Query Folding to the end. Or do you… If curious, please continue reading...

What if when Power BI was released all those years ago that it defaulted to table and matrix totals simply summing the rows? Let's explore this alternate reality and how you would handle displaying an alternate summary of information in a table or matrix.

Power BI offers a good set of in-built visuals which you can access and use from the Visualization pane in Power BI Desktop.

The new Datamarts feature that was just announced in Microsoft build has a very special bonus for all the Mac developers that always wanted to work on Power BI Desktop but couldn't let go of their Mac..

Automatic aggregations will help unlock huge datasets for interactive analysis, enhance query performance, and enable interactive analysis over big data.

Some consider EARLIER a relic of the bygone era when DAX did not support variables, criticize it's name and do not recommend using it but is EARLIER really that bad?

The Explicit Measures Podcast is a Power BI focused show that is like being around a Power BI Pro’s Water Cooler. With so many available resources in the community that focuses on the “how” in Power BI (how to do Drill Through, how to use DAX, etc.,), the Explicit Measures Podcast is all around the WHY. Why use a particular feature, does it make sense for my users?

Build the toolset, learn the how, and then come to the Podcast to listen to the why in situations we all experience as Power BI Pros.

So, this question came up in the forums about whether Tabular Editor 3, the paid version, was "worth it". I gave a bit of a cheeky response but figured this topic deserved a more thorough answer...

You see it all the time in the forums, a question comes in about how to do a particular calculation in DAX and someone responds "You shouldn't use DAX for that, use Power Query." Well, yes and no...

Have you ever wanted to add a toggle feature to your Power BI Desktop Report, but don't know how? Well the good news - it is easy to do, and even better news I will show you how to 🙂 

Power BI gives us a flexibility of using custom visuals in variety of scenarios to take our reports to the next level. Today in this blog I will be talking about Comicgen custom visual in a particular scenario to show how this visual can add a bit of emotion and pose visually to your report. 

What could happen with using the Sort By Column setting? Keep reading to find out!