Category: dax
-
Take a Deep Dive into Filtering in DAX
Take a Deep Dive into Filtering in DAX Have you ever wondered what happens when you apply a filter in a DAX expression? Well, Today I will take you on a deep dive into this fascinating topic, with examples to help you learn something new and surprising. The post Take a Deep Dive into Filtering…
-
Does Calendar-Based Time-Intelligence Change Custom Logic?
Does Calendar-Based Time-Intelligence Change Custom Logic? Let’s look at calculating the moving average over time The post Does Calendar-Based Time-Intelligence Change Custom Logic? appeared first on Towards Data Science. Salvatore Cagliari Go to original source
-
How to Implement Three Use Cases for the New Calendar-Based Time Intelligence
How to Implement Three Use Cases for the New Calendar-Based Time Intelligence Starting with the September 2025 Release of Power BI, Microsoft introduced the new Calendar-based Time Intelligence feature. Let’s see what can be done by implementing three use cases. The future looks very interesting with this new feature. The post How to Implement Three…
-
A Real-World Example of Using UDF in DAX
A Real-World Example of Using UDF in DAX With the September 2025 release of Power BI, we get the new user-defined function feature. This is an excellent addition to our toolset. Let’s see how to build a real-world example of this new feature. The post A Real-World Example of Using UDF in DAX appeared first…
-
How to Correctly Apply Limits on the Result in DAX (and SQL)
How to Correctly Apply Limits on the Result in DAX (and SQL) What if the output of a measure mustn’t be above a specific limit? How can we ensure that the total is calculated correctly? This piece is about correctly calculating and summarizing such output. The post How to Correctly Apply Limits on the Result…
-
On Adding a Start Value to a Waterfall Chart in Power BI
On Adding a Start Value to a Waterfall Chart in Power BI A waterfall chart can be a powerful tool for conveying information. But it has some limitations. The post On Adding a Start Value to a Waterfall Chart in Power BI appeared first on Towards Data Science. Salvatore Cagliari Go to original source
-
Why You Should Not Replace Blanks with 0 in Power BI
Why You Should Not Replace Blanks with 0 in Power BI Did someone ask you to replace blank values with 0 in your reports? Maybe you should think twice before you do it! The post Why You Should Not Replace Blanks with 0 in Power BI appeared first on Towards Data Science. Nikola Ilic Go…
-
About Calculating Date Ranges in DAX
About Calculating Date Ranges in DAX When performing date calculations, creating date ranges can be helpful. But how can we do this, and which DAX function can help us in which case? Now you can learn more about this topic. The post About Calculating Date Ranges in DAX appeared first on Towards Data Science. Salvatore…
-
How to Develop Complex DAX Expressions
How to Develop Complex DAX Expressions At some point or another, any Power BI developer must write complex Dax expressions to analyze data. But nobody tells you how to do it. What’s the process for doing it? What is the best way to do it, and how supportive can a development process be? These are the questions…
-
Advanced Time Intelligence in DAX with Performance in Mind
Advanced Time Intelligence in DAX with Performance in Mind We all know the usual Time Intelligence function based on years, quarters, months, and days. But sometimes, we need to perform more exotic timer intelligence calculations. But we should not forget to consider performance while programming the measures. Introduction There are many Dax functions in Power BI…
-
How to do Date calculations in DAX
How to do Date calculations in DAX Moving back and forth in time is a common task for Time Intelligence in DAX. Let’s take a deeper look on how DATEADD() works. Continue reading on Towards Data Science » Salvatore Cagliari Go to original source