Fixed Dax Guide

Summary

FIND: Returns the starting position of one text string within another text string. FIND is case-sensitive and accent-sensitive. The IN operator returns TRUE if a row of values exists or contained in a table, otherwise returns FALSE. EXACT: Checks whether two text strings are exactly the same, and returns TRUE or FALSE. EXACT is case-sensitive. FACT: Returns the factorial of a number, equal to 1*2*3*…* Number. SQRTPI: Returns the square root of (number * pi). REPT: Repeats text a given number of times. Use REPT to fill a cell with a number of instances of a text string. ISSUBTOTAL: Returns TRUE if the current row contains a subtotal for a specified column and FALSE otherwise. ISEMPTY: Returns true if the specified table or table-expression is Empty.