DAX.pptx fgrrerrerererererere rerer er eree r er

basics of pythom

1. DAX DAX, which stands for Data Analysis Expressions, is a formula language used in Power BI, Power Pivot, and SQL Server Analysis Services (SSAS) for creating custom calculations and data analysis. DAX is a powerful and flexible language designed specifically for data modeling, analysis, and reporting. By : Aishwarya Mate

2. Purpose of DAX: Enables custom calculations and data analysis within Power BI. Key Features: Calculated Columns: Created based on DAX formulas and stored in the data model. Measures: Dynamic calculations performed on the fly within visuals and reports. Custom Tables: Generate new tables using DAX formulas.

3. MEASURES IN DAX Measure in DAX is a single value that we calculate from any column. Measures often use aggregation functions like SUM, AVERAGE, MIN, MAX, COUNT, DISTINCTCOUNT, etc., to summarize data. Measures are calculated for any column, i.e. Numerical, Text, Date. Common Measures for Numerical Columns in Power BI Sum Average Minimum Maximum Count Distinct Count Count Rows

4. Order table:

5. New Column A new column in DAX refers to a calculated column that you create within a table in your Power BI model. This column is computed during the data refresh process and is stored as part of the underlying data model. DAX

6. Iterator Functions Iterator functions in DAX (Data Analysis Expressions) in Power BI are functions that perform row-by-row operations over a table and then aggregate the results. Unlike simple aggregation functions that operate on entire columns, iterator functions can work with complex expressions involving multiple columns and calculations for each row. SUMX AVERAGEX MINX MAXX COUNTX

7. Total Revenue: TotalRevenue = SUMX(Sales, Sales[Quantity] * Sales[Price])

8. Average Revenue: Average Revenue = AVERAGEX(Sales, Sales[Quantity] * Sales[Price])

9. RANKX Rank = RANKX(Students, Students[Score], , DESC, DENSE)

10. TIME INTELLIGENCE FUNCTIONS In Data Analysis Expressions (DAX), which is used in Microsoft Power BI, Excel Power Pivot, and SQL Server Analysis Services (SSAS), time intelligence functions are specialized functions designed to work with dates and times. These functions enable you to perform calculations such as year-to-date totals, cumulative totals, which are common in financial and other analytical scenarios where time-based comparisons are crucial.

11. TOTALYTD It stands for "Total Year-To-Date" and is designed to calculate cumulative totals from the beginning of the year up to the current date for a specified expression.

12. Total Sales YTD = TOTALYTD(SUM(Sales[SalesAmount]), Sales[Date column].[Date])

13. Table Dax FILTER CALCULATETABLE

14. Filter The FILTER function returns a table that represents a subset of another table or expression. It allows to extract the table by applying filter only on one column at a time. Syntax : For 1 condition: tablename = FILTER(Tablename, Table[Column] = ‘Value’) For 2 conditions: tablename = FILTER(Tablename, OR(Table[Column] = ‘Value’ ,Table[Column] = ‘Value’)) For more than 2 conditions: tablename = FILTER(Tablename, Table[Column] in {‘Value1’, ‘Value2’, ‘Value3})

15. Calculate Table Calculate table is used when we need to apply filter on more than one column. Syntax : Tablename = CALCULATETABLE(Table, Filter1, Filter2)