Welcome to On Statistics
-
Power BI Tutorial: How to Use RELATED & LOOKUP
Power BI excels at analyzing data across multiple tables, and two key functions empower this functionality: RELATED and LOOKUP. This tutorial equips you to navigate relationships and extract specific data points based on conditions, unlocking rich insights from your data. Step 1: Understanding Relationships Step 2: RELATED – Extracting Related Data Step 3: LOOKUP –…
-
Power BI Tutorial: DATE, FORMAT, IF – Unlocking User-Friendly and Informative Visuals
Power BI visualizations are powerful tools, but the way your data is formatted and displayed plays a crucial role in their effectiveness. This tutorial explores three essential functions – DATE, FORMAT, and IF – to enhance your visualizations, making them user-friendly and informative. Step 1: Mastering Dates with DATE and FORMAT Imagine displaying raw dates…
-
Power BI: Learn To Use Simple Sum And Expressive SUMX
In Power BI, both SUM and SUMX perform calculations on your data, but they do so in different ways and serve distinct purposes. This tutorial will guide you through the differences, helping you choose the right tool for your analysis needs. Step 1: Understanding the Basics Step 2: When to Use SUM: Step 3: When…
