Post #1942

Commonly used Power BI DAX functions: DATE AND TIME FUNCTIONS: - CALENDAR - DATEDIFF - TODAY, DAY, MONTH, QUARTER, YEAR AGGREGATE FUNCTIONS: - SUM, SUMX, PRODUCT - AVERAGE - MIN, MAX - COUNT - COUNTROWS - COUNTBLANK - DISTINCTCOUNT FILTER FUNCTIONS: - CALCULATE - FILTER - ALL, ALLEXCEPT, ALLSELECTED, REMOVEFILTERS - SELECTEDVALUE TIME INTELLIGENCE FUNCTIONS: - DATESBETWEEN - DATESMTD, DATESQTD, DATESYTD - SAMEPERIODLASTYEAR - PARALLELPERIOD - TOTALMTD, TOTALQTD, TOTALYTD TEXT FUNCTIONS: - CONCATENATE - FORMAT - LEN, LEFT, RIGHT INFORMATION FUNCTIONS: - HASONEVALUE, HASONEFILTER - ISBLANK, ISERROR, ISEMPTY - CONTAINS LOGICAL FUNCTIONS: - AND, OR, IF, NOT - TRUE, FALSE - SWITCH RELATIONSHIP FUNCTIONS: - RELATED - USERRELATIONSHIP - RELATEDTABLE Remember, DAX is more about logic than the formulas.