Power Bi

We all the time use filters when developing DAX expressions, reminiscent of DAX measures, or when writing DAX queries. But what happens exactly after we apply filters? This piece is strictly about this query. I'll start with...

Introduction calendar-based Time Intelligence, the necessity for custom Time Intelligence logic has decreased dramatically. Now, we will create custom calendars to fulfill our Time Intelligence calculation needs. You may have read my article about advanced Time...

there: You open Power BI, drag a messy Excel sheet into the canvas, and begin dropping charts until something looks “right.” It’s easy, it’s intuitive, and truthfully, that’s why Power BI is one...

Imagine that we have now three measures: Sales Amount Sales Amount Budget Sales Amount PY Once we take a look at a table with these numbers, we see this (assuming that we have now current data until the...

This can be a typical case for Self-Service BI with Excel data. Just a few days ago, a client asked me the next query: I actually have an Excel sheet with numbers and text in a...

Introduction about Time Intelligence in DAX up to now. Nonetheless, the brand new Calendar-based Time Intelligence feature rewrites the rulebook, as some concepts will change, and the required techniques will likely be simpler than before. Anyway,...

used a Composite model feature in Power BI, you would possibly have already heard about one other extremely necessary and powerful concept – Aggregations! It’s because in lots of scenarios, especially with enterprise-scale...

Introduction The feature of user-defined functions was introduced as a primary preview version with the September 2025 release. This feature enables us to encapsulate business logic in functions, which may be called like several other standard...