Ankit Srivastava

Ankit Srivastava is an IT trainer, technology educator, and digital skills mentor with expertise in programming, data analytics, AI, and software development. He has successfully trained thousands of learners, with more than 10,000 student enrollments on Udemy. His practical teaching approach empowers students and professionals to build in-demand technical skills. Colorstech channel where Ankit posts video tutorials has more than 8000 Subscribers.

AVERAGE vs AVERAGEX DAX Function Difference with Example

Here is the the difference between AVERAGE vs AVERAGEX with a realistic example using your Hospital Patient Treatment Dataset (which includes patients, doctors, recovery scores, treatment cost, etc.). ❓ Question: What is the average of the average recovery score per doctor? 🔍 Why This Matters: Here is the dataset snapshot ✅ DAX Using AVERAGEX (Correct

AVERAGE vs AVERAGEX DAX Function Difference with Example Read More »

Top “This vs That” DAX Function Comparisons

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

Top “This vs That” DAX Function Comparisons Read More »

stdev.p and stdev.s dax example

Difference between STDEV.S and STDEV.P in DAX with Example

🎯 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 »

Why Every Technical Student Must Master Git & Version Control

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 »

🛠️ 5 More Useful Features in Power Query Editor with Explanation

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 »