DAX Tutorial: Search and Find Function in Power BI.
Introduction to Search and Find Functions The search and find functions in Power BI DAX are used to search for a specific value within a …
Power Bi
Power BI is a collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights. Your data might be an Excel spreadsheet, or a collection of cloud-based and on-premises hybrid data warehouses. Power BI lets you easily connect to your data sources, visualize and discover what’s important, and share that with anyone or everyone you want.
DAX Tutorial: Left and Right Function in Power BI.
In this tutorial, we will focus on the Left and Right functions in DAX, which are used to extract a specified number of characters from …
DAX Tutorial: Cross Filter in Power BI.
What is a Cross Filter? A cross filter in Power BI DAX is a filtering technique that allows data to flow from one table to …
DAX Tutorial: Distinct Count in Power BI.
Introduction to Distinct Count in Power BI One of the key features of Power BI is the ability to perform calculations using the Data Analysis …
DAX Tutorial: MAX, MAXX, and MAXA in Power BI.
Introduction In this tutorial, we will explore three important functions in DAX: MAX, MAXX, and MAXA. These functions are used to find the maximum value …
DAX Tutorial: Sequence Number or Serial Number or Row Number in Power BI.
Introduction One common requirement in data analysis is to assign a unique identifier to each row in a table. This identifier is often referred to …
DAX Tutorial: All Selected function in Power BI.
The All Selected function is a powerful tool in Power BI’s Data Analysis Expressions (DAX) language. It allows you to remove filters from a specific …
DAX Tutorial: Running Total or Cumulative Total of Non Date Columns in Power BI.
One common requirement in data analysis is to calculate the running total or cumulative total of non-date columns. In this tutorial, we will explore how …
DAX Tutorial: Moving Averages / Rolling Averages in Power BI.
Introduction In Power BI, the DAX (Data Analysis Expressions) language is used to create formulas and expressions that can be used to calculate various metrics …
DAX Tutorial: Default Report to Latest Fact Date in Power BI.
Introduction In Power BI, the ability to create dynamic reports that automatically update to show the latest data is crucial for effective data analysis. One …