mailitics

Category: power-bi

  • 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

  • Beyond the Flat Table: Building an Enterprise-Grade Financial Model in Power BI

    Beyond the Flat Table: Building an Enterprise-Grade Financial Model in Power BI A step-by-step journey through data transformation, star schema modeling, and DAX variance analysis with lessons learned along the way. The post Beyond the Flat Table: Building an Enterprise-Grade Financial Model in Power BI appeared first on Towards Data Science. Ibrahim Salami Go to original source

  • How to Filter for Dates, Including or Excluding Future Dates, in Semantic Models

    How to Filter for Dates, Including or Excluding Future Dates, in Semantic Models It is common to have either planning data or the previous year’s data displayed beyond today’s date. But future data can be confusing. How can I add a Slicer to show or hide future data? Let’s see how to do it. The…

  • Separate Numbers and Text in One Column Using Power Query

    Separate Numbers and Text in One Column Using Power Query An Excel sheet with a column containing numbers and text? What a mess! The post Separate Numbers and Text in One Column Using Power Query 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…

  • The Ultimate Guide to Power BI Aggregations

    The Ultimate Guide to Power BI Aggregations Aggregations are one of the most powerful features in Power BI — learn how to leverage this feature to improve the performance of your Power BI solution The post The Ultimate Guide to Power BI Aggregations appeared first on Towards Data Science. Nikola Ilic Go to original source

  • 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…

  • Everything You Need to Know About the New Power BI Storage Mode

    Everything You Need to Know About the New Power BI Storage Mode 50 Shades of Direct Lake The post Everything You Need to Know About the New Power BI Storage Mode appeared first on Towards Data Science. Nikola Ilic Go to original source

  • 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

  • What Is a Query Folding in Power BI and Why should You Care?

    What Is a Query Folding in Power BI and Why should You Care? “Will that break a query folding?” “Does your query fold?”… Maybe someone asked you those questions, but you were like: “Query…Whaaaat?! In this article, we demistify the query folding and its importance for efficient data refresh in Power BI The post What…

  • Implementing IBCS rules in Power BI

    Implementing IBCS rules in Power BI Is there a way to use the out-of-the-box features of Power BI to be IBCS compliant? The post Implementing IBCS rules 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…

  • How Microsoft Power BI Elevated My Data Analysis and Visualization Workflow

    How Microsoft Power BI Elevated My Data Analysis and Visualization Workflow Explaining useful features every data analyst needs The post How Microsoft Power BI Elevated My Data Analysis and Visualization Workflow appeared first on Towards Data Science. Benjamin Nweke Go to original source

  • How to Reduce Your Power BI Model Size by 90%

    How to Reduce Your Power BI Model Size by 90% Have you ever wondered what makes Power BI so fast and powerful when it comes to performance? Learn on a real-life example about data model optimization and general rules for reducing data model The post How to Reduce Your Power BI Model Size by 90%…

  • How to Get Performance Data from Power BI with DAX Studio

    How to Get Performance Data from Power BI with DAX Studio Introduction To put things straight: I will not discuss how to optimize DAX Code today. More articles will follow, concentrating on common mistakes and how to avoid them. But, before we can understand the performance metrics, we need to understand the architecture of the…

  • How to Write Queries for Tabular Models with DAX

    How to Write Queries for Tabular Models with DAX Introduction EVALUATE is the statement to query tabular models. Unfortunately, knowing SQL or any other query language doesn’t help as EVALUATE follows a different concept. EVALUATE has only two “Parameters”: A table to show A sort order (ORDER BY) You can pass a third parameter (START…

  • 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 Create Network Graph Visualizations in Microsoft PowerBI

    How to Create Network Graph Visualizations in Microsoft PowerBI Microsoft PowerBI is a one of the most popular Business Intelligence (BI) tools, and while it has all the features you need to create dynamic analytic reporting for stakeholders across the business, creating some advanced data visualizations is more challenging. This article will walk through how…

  • 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

  • My Experience Switching From Power BI to Looker (as a Senior Data Analyst)

    My Experience Switching From Power BI to Looker (as a Senior Data Analyst) What you need to know before you switch from Power BI to Looker. Continue reading on Towards Data Science » Tomas Jancovic (It’s AI Thomas) Go to original source