Quick Power BI Functions Cheat Sheet for Beginners 📊✍️

Aggregation Functions (DAX)
• SUM(column): Returns the total of a column.
• AVERAGE(column): Calculates the average value.
• COUNT(column): Counts non-blank rows in a column.
• DISTINCTCOUNT(column): Counts unique values.
• MAX(column): Returns the highest value.
• MIN(column): Returns the lowest value.

Filter Functions
• FILTER(table, condition): Returns a filtered table based on a condition.
• ALL(table/column): Removes filters from a table or column.
• ALLEXCEPT(table, column): Removes all filters except specified columns.
• VALUES(column): Returns unique values from a column.

Logical Functions
• IF(condition, true_result, false_result): Performs conditional logic.
• SWITCH(expression, value1, result1, …): Evaluates multiple conditions.
• AND(condition1, condition2): Returns TRUE if both conditions are true.
• OR(condition1, condition2): Returns TRUE if any condition is true.

Date Time Functions
• TODAY(): Returns the current date.
• NOW(): Returns the current date and time.
• YEAR(date): Extracts the year from a date.
• MONTH(date): Extracts the month from a date.
• DATEDIFF(date1, date2, interval): Returns the difference between two dates.

Text Functions
• CONCATENATE(text1, text2): Joins two text values.
• LEFT(text, num_chars): Extracts characters from the left.
• RIGHT(text, num_chars): Extracts characters from the right.
• LEN(text): Returns the length of text.
• FORMAT(value, text, format_string): Converts value to formatted text.

Relationship Functions
• RELATED(column): Fetches data from a related table.
• RELATEDTABLE(table): Returns related rows from another table.
• USERELATIONSHIP(column1, column2): Activates an inactive relationship.

Power BI Resources: https://whatsapp.com/channel/0029Vai1xKf1dAvuk6s1v22c

Double Tap ♥️ For More