Filter Functions in DAX
When working in Power BI or Power Pivot, one of the most important concepts you’ll come across is filtering data. […]
DAX Functions
DAX Functions
Iterator Functions in DAX
If you are learning DAX (Data Analysis Expressions) for Power BI or Power Pivot, you will quickly notice that some
DAX Functions
Basic DAX Functions
DAX, or Data Analysis Expressions, is the backbone of Power BI, Power Pivot, and Analysis Services. It allows users to
DAX Functions
Introduction to DAX
Welcome to the first lesson in our DAX series on Smart Tutorials! If you are looking to analyze data, create
Excel Functions Cheat Sheet: From Basics to Advanced
Mastering Excel functions is the key to becoming an efficient MIS analyst, data professional, or even a power user in
10 Advanced Excel Questions for MIS Interview
Are you ready to push your Excel skills beyond the basics? In Part-1 we covered 20 practical Excel questions that
Think You Know Excel? Try These 20 Real-World Excel Questions
If you are preparing for an Excel interview or want to sharpen your skills for MIS and reporting jobs, practice
Google Sheets
Other Google Sheets Functions
Google Sheets is a powerful tool, not just for creating spreadsheets, but also for analyzing, automating, and visualizing data. While
Blinkit Sales Dashboard in Power BI
Power BI has become one of the most powerful tools for data visualization and business intelligence. In this project, I
Google Sheets
SPLIT Function in Google Sheets
When you are working in Google Sheets, many times you get data that is combined in one cell — like
Google Sheets
UNIQUE Function in Google Sheets
When you are working with large datasets in Google Sheets, one of the most common problems is dealing with duplicate
Google Sheets
FILTER function in Google Sheets
When you are working with large datasets in Google Sheets, scrolling endlessly or applying manual filters again and again can