Here are Top โThis vs Thatโ DAX Function Comparisons with explanation Topic Function 1 Function 2 Key Difference 1. Standard Deviation STDEV.S STDEV.P Sample vs Population (n-1 vs n) 2. SUM vs SUMX SUM() SUMX() Simple aggregation vs row-by-row evaluation 3. AVERAGE vs AVERAGEX AVERAGE() AVERAGEX() Aggregation vs iteration over rows 4. CALCULATE vs CALCULATETABLE …
๐ฏ Objective Show the difference between STDEV.S() and STDEV.P() DAX functions using real-world data from the Sample Superstore dataset (e.g., Orders table). ๐ Quick Definitions Function Meaning Divisor Used When to Use STDEV.S() Sample Standard Deviation Divides by n – 1 Use when data is a sample of the population STDEV.P() Population Standard Deviation Divides …
Difference between STDEV.S and STDEV.P in DAX with Example Read More »
A Directorโs Perspective After 10+ Years in the Trenches By Ankit, Technical Director, Slidescope The Reality Check Letโs start with a hard truth. In my 10+ years of building software โ from solo coding nights to leading teams at Slidescope building real-time collaborative systems โ one skill consistently separates the prepared from the panicked: Version …
Why Every Technical Student Must Master Git & Version Control Read More »
At Slidescope we have taught 10000+ students and those who want to build their career as a data analyst always have this question in mind, “How to start my career as a Data Analyst?”. Many blogs and website will tell you about this technology that technology etc. But you should start with understanding what is …
๐ What it does: FIRSTDATE() returns the first (earliest) date in the current filter context from a column of dates. ๐งฎ Syntax: โ Example: This returns the earliest date where data exists based on the current filters (e.g., per region, product, month, etc.). ๐ง Used with CALCULATE: Example: Get sales on the first date of …
FIRSTDATE() in Power BI DAX โ Description & Example Read More »
Here’s a short description and example of PARALLELPERIOD() in Power BI DAX: ๐ What it does: PARALLELPERIOD() shifts the dates in the current context by a specified number of intervals (month, quarter, or year) โ but keeps the same length of period. ๐งฎ Syntax: ๐งฎ Example: Previous Year Sales ๐ How it works: Year Month …
Using this dataset, you can practice these advanced or frequently used features: 1. ๐ Filter Rows Based on Conditions Use Case: View only employees who worked in “New York” ๐ง Steps: โ Result: Only rows where Location is โNew Yorkโ are kept. Real-Life Benefit: Helpful when creating location-specific dashboards. 2. ๐ชTime Column Cleaning โ Objective: …
๐ ๏ธ 5 More Useful Features in Power Query Editor with Explanation Read More »
Here’s a curated list of the 50 most important DAX functions โ grouped by category โ that every Power BI Developer should know for interviews, certifications, and real-world use. ๐ Date & Time Functions โณ Time Intelligence Functions ๐ข Math & Aggregation Functions ๐ง Logical & Conditional Functions ๐ Filter Functions ๐ Relationship & Table …
โ Sample Dataset: Employee Work Hours (Synthetic) EmployeeID Name Department Date CheckInTime CheckOutTime Location E001 Alice HR 2024-06-01 09:15 17:45 New York E002 Bob Finance 2024-06-01 09:30 18:00 Chicago E003 Charlie IT 2024-06-01 10:00 19:00 San Francisco E004 Diana HR 2024-06-01 09:00 17:00 New York E005 Edward IT 2024-06-01 11:00 20:00 Chicago Hereโs a mini …
Power Query Editor 3 different features of it on Employee Data Read More »
In DAX (Data Analysis Expressions), the PRODUCTX function multiplies all the values of a given expression evaluated over a table. Syntax of PRODUCTX: PRODUCTX(table, expression) table: The table to iterate over. expression: The expression to evaluate and multiply across each row. ๐ฏ Use Case: Calculating Compound Growth (Multiplicative Change) Letโs say we have a table …
We teach programming languages and tools that are used by industries and generate jobs.
Get certificates on completion of courses. Our certificates have helped many students in getting placed in reputed companies. Students have presented our certificate to top universities to prove their qualification for various programming languages.
