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
1July 4, 2026 993 4
