String Dax Guide

Summary

SELECTEDMEASUREFORMATSTRING: Returns format CONTAINSSTRING: Returns TRUE if one text ISERROR: Checks whether a value is an error, and returns TRUE or FALSE. SUBSTITUTEWITHINDEX: Returns a table which represents the semijoin of two tables supplied and for which the common set of ... GENERATE: The second table expression will be evaluated for each row in the first table. Returns the crossjoin of the first table ... SQRTPI: Returns the square root of (number * pi). PERMUT: Returns the number of permutations for a given number of objects that can be selected from number objects. ROLLUPISSUBTOTAL: Pairs up the rollup groups with the column added by ROLLUPADDISSUBTOTAL. FORMAT: Converts a value to text in the specified number format. FIND: Returns the starting position of one text FIXED: Rounds a number to the specified number of decimals and returns the result as text with optional commas. ROLLUPGROUP: Identifies a subset of columns specified in the call to SUMMARIZE function that should be used to calculate ...