Top 10 DAX formula to learn i n power bi for Data Analysis
Top 10 DAX formula to learn i n power bi for Data Analysis
This is a very powerful and versatile formula that allows you to modify the filter context of a calculation. It is essential to master this formula to create more advanced calculations.
This is a very powerful and versatile formula that allows you to modify the filter context of a calculation. It is essential to master this formula to create more advanced calculations.
CALCULATE
CALCULATE
This formula is used to iterate over a table and calculate the sum of an expression for each row. It is useful for creating more complex calculations that involve multiple tables.
This formula is used to iterate over a table and calculate the sum of an expression for each row. It is useful for creating more complex calculations that involve multiple tables.
SUMX
SUMX
AVERAGE
AVERAGE
Title
This formula calculates the arithmetic mean of a column or expression. It is a commonly used formula for calculating averages.
This formula calculates the arithmetic mean of a column or expression. It is a commonly used formula for calculating averages.
FILTER:
FILTER:
This formula is used to filter a table or expression based on a specified condition. It is useful for creating more complex calculations that involve filtering data.
This formula is used to filter a table or expression based on a specified condition. It is useful for creating more complex calculations that involve filtering data.
MAX/MIN
MAX/MIN
These formulas are used to return the maximum or minimum value of a column or expression. They are commonly used in calculations involving ranking or finding the highest/lowest value.
These formulas are used to return the maximum or minimum value of a column or expression. They are commonly used in calculations involving ranking or finding the highest/lowest value.
IF:
IF:
This formula allows you to specify a condition and return one value if the condition is true, and another value if the condition is false. It is a useful formula for creating conditional calculations.
This formula allows you to specify a condition and return one value if the condition is true, and another value if the condition is false. It is a useful formula for creating conditional calculations.
SWITCH
SWITCH
This formula is similar to the IF formula, but allows you to specify multiple conditions and return a different value for each condition. It is useful for creating more complex conditional calculations.
This formula is similar to the IF formula, but allows you to specify multiple conditions and return a different value for each condition. It is useful for creating more complex conditional calculations.
RELATED
RELATED
This formula is used to retrieve data from a related table in a data model. It is useful for creating calculations that involve multiple tables.
This formula is used to retrieve data from a related table in a data model. It is useful for creating calculations that involve multiple tables.
big data and AI aided decision making solutions for all.
big data and AI aided decision making solutions for all.
DATE:
DATE:
"Master Data Analytics with Expert-led Training. Enroll Now!"
"Master Data Analytics with Expert-led Training. Enroll Now!"