DAX Tutorial: TREATAS Function in Power BI.
In Power BI, the Data Analysis Expressions (DAX) language provides powerful functions to manipulate and analyze data. One such function is TREATAS, which allows you …
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: RANKX in Power BI.
The Power BI DAX RANKX function is a powerful sortation function. We will give an overview of what the RANKX function is capable of and …
DAX Tutorial: Understanding the “ALL” and “ALLEXCEPT” Functions in Power BI
One of the key features of Power BI is its ability to create complex calculations and measures using DAX (Data Analysis Expressions) formulas. In this …
DAX Tutorial: HASONEVALUE Function in Power BI.
The HASONEVALUE function is a DAX function in Power BI that returns a Boolean value of true or false, depending on whether a column has …
DAX Tutorial: Related Function in Power BI.
The RELATED function requires that a regular relationship exists between the current table and the table with related information. The argument specifies a column reference, …
DAX Tutorial: DATESBETWEEN Function in Power BI
One of the key functions in Power BI is the DATESBETWEEN function, which enables users to filter data based on a specified date range. In …
DAX Tutorial: DatesInPeriod Function in Power BI.
The DatesInPeriod function in Power BI returns a table that contains a column of dates that begins with the start_date and continues for the specified …
DAX Tutorial: What is the DATEDADD Function in Power BI.
One of the frequently used functions in DAX is the DATEDADD function. The DATEDADD function allows you to add or subtract a specified number of …
DAX tutorial: Comparing Previous Month, Year, and Quarter
If you want to compare the sales up to a particular day and compare it with the previous period (month, quarter, or year) but up …
DAX tutorial: SamePeriodLastYear in Power BI
Introduction SAMEPERIODLASTYEAR in Power BI is great way to simplify the analysis of year over year performance. One common requirement in data analysis is to …