DAX Tutorial: Selected Value in Power BI.
The function selected value returns the value of the column reference passed as first argument if it is the only value available in the filter context, …
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: Variables in Power BI.
In Power BI, the Data Analysis Expressions (DAX) language is used to create formulas and expressions for calculations. One important feature of DAX is the …
DAX Tutorial: Distinct Function in Power BI.
DISTINCT function is used to retrieve unique values from a column or a table in Power BI. The DISTINCT function eliminates duplicate values and returns …
DAX Tutorial: UNION, INTERSECT, and EXCEPT in Power BI.
In DAX (Data Analysis Expressions), UNION, INTERSECT, and EXCEPT are powerful operators that allow you to combine or compare data from multiple tables or queries. …
DAX Tutorial: Summarize Function in power bi.
In the world of data analysis and modeling, the Summarize function is a powerful tool that is widely used in the DAX (Data Analysis Expressions) …
DAX tutorial: Difference Between TotalYTD vs DatesYTD Function.
In DAX (Data Analysis Expressions), the TotalYTD and DatesYTD functions are commonly used to calculate the year-to-date values in Power BI, Power Pivot, and Analysis …
DAX Tutorial: RemoveFilters in Power bi.
Filters can be applied at different levels, such as at the table, column, or row level. However, there are situations where you may want to …
DAX Tutorial: Keepfilters Function in Power BI.
The KEEPFILTERS function allows you to modify this behavior. When you use KEEPFILTERS, any existing filters in the current context are compared with the columns …
DAX Tutorial: Switch Function in Power BI
One of the key features of Power BI is its ability to perform calculations and create custom expressions using DAX (Data Analysis Expressions) functions. One …
DAX Tutorial: LookupValue Function in Power BI.
One of the key functions in Power BI is the LookupValue function, which enables users to retrieve data from one table based on a matching …