--- title: "Shahnawaz Khan (@Shahnawaz2024) | Hashnode" description: "Data Analyst | Excel | SQL | Power BI | ETL | Python | Statistics | Machine Learning | PySpark | Databricks | Snowflake" url: "https://hashnode.com/@Shahnawaz2024" --- @Shahnawaz2024 # Shahnawaz Khan @Shahnawaz2024 · Maharashtra, Pune. · Joined July 2024 Data Analyst | Excel | SQL | Power BI | ETL | Python | Statistics | Machine Learning | PySpark | Databricks | Snowflake ### [🌟 Unlock the Power of CROSSFILTER in Power BI! 🌟](https://shahnawaz.hashnode.dev/unlock-the-power-of-crossfilter-in-power-bi?utm_source=hashnode&utm_medium=feed) If you're working with relationships between tables in Power BI, you might have wondered how to control the flow of data between them. That’s where CROSSFILTER steps in like a superhero! 🦸‍♂️ What is CROSSFILTER?CROSSFILTER is a DAX function that le... 2 min read · [shahnawaz.hashnode.dev](https://shahnawaz.hashnode.dev/unlock-the-power-of-crossfilter-in-power-bi?utm_source=hashnode&utm_medium=feed) [Jan 7, 2025](https://hashnode.com/posts/unlock-the-power-of-crossfilter-in-power-bi/677cb897311ef1c7e593e2b9) ### [✨ Understanding SELECTEDVALUE in Power BI – Simplified! ✨](https://shahnawaz.hashnode.dev/understanding-selectedvalue-in-power-bi-simplified?utm_source=hashnode&utm_medium=feed) Ever wondered how to display the value selected in a slicer or filter in Power BI? That’s where SELECTEDVALUE comes to the rescue! 🚀 What is SELECTEDVALUE?It’s a simple yet powerful DAX function that returns the value selected in a column. If multip... 1 min read · [shahnawaz.hashnode.dev](https://shahnawaz.hashnode.dev/understanding-selectedvalue-in-power-bi-simplified?utm_source=hashnode&utm_medium=feed) [Jan 6, 2025](https://hashnode.com/posts/understanding-selectedvalue-in-power-bi-simplified/677b6773844f48294c093e4d) ### [🌟 Kickstart Your Journey to Becoming a Data Analyst in 2025! 🚀](https://shahnawaz.hashnode.dev/kickstart-your-journey-to-becoming-a-data-analyst-in-2025?utm_source=hashnode&utm_medium=feed) ✨ New Year, New Goals! ✨If you've been dreaming of stepping into the world of Data analytics, 2025 is your year! Data is the backbone of modern businesses and skilled Data Analysts are more in demand than ever. Here's your ultimate guide to starting ... 2 min read · [shahnawaz.hashnode.dev](https://shahnawaz.hashnode.dev/kickstart-your-journey-to-becoming-a-data-analyst-in-2025?utm_source=hashnode&utm_medium=feed) [Jan 1, 2025](https://hashnode.com/posts/kickstart-your-journey-to-becoming-a-data-analyst-in-2025/6774e56d88ab2b726b831e39) ### [Group By & Summarize in Power BI: Your Secret to Organized Data! 🔍](https://shahnawaz.hashnode.dev/group-by-summarize-in-power-bi-your-secret-to-organized-data?utm_source=hashnode&utm_medium=feed) If you’ve ever worked on large datasets, you know the struggle of making sense of all that information. That’s where Group By and Summarize in Power BI come to the rescue! 🚀Here’s why they’re a game changer:👉 Group By:This feature allows you to bun... 1 min read · [shahnawaz.hashnode.dev](https://shahnawaz.hashnode.dev/group-by-summarize-in-power-bi-your-secret-to-organized-data?utm_source=hashnode&utm_medium=feed) [Dec 31, 2024](https://hashnode.com/posts/group-by-summarize-in-power-bi-your-secret-to-organized-data/677386153cbf5fe589e43733) ### [🌟 SUMMARIZE vs SUMMARIZECOLUMNS in Power BI: Which One Should You Use? 🌟](https://shahnawaz.hashnode.dev/summarize-vs-summarizecolumns-in-power-bi-which-one-should-you-use?utm_source=hashnode&utm_medium=feed) When working in Power BI, sometimes you need to create summary tables to group your data or calculate totals. That’s where SUMMARIZE and SUMMARIZECOLUMNS come in! Both are used to summarize data, but they work in slightly different ways. Let’s break ... 2 min read · [shahnawaz.hashnode.dev](https://shahnawaz.hashnode.dev/summarize-vs-summarizecolumns-in-power-bi-which-one-should-you-use?utm_source=hashnode&utm_medium=feed) [Dec 30, 2024](https://hashnode.com/posts/summarize-vs-summarizecolumns-in-power-bi-which-one-should-you-use/67722ad8ae620cc7692551c0)