If Dax Guide

Summary

In this short video, we'll walk you through the FIND: Returns the starting position of one text string within another text string. FIND is case-sensitive and accent-sensitive. Learn the details about how the ISERROR: Checks whether a value is an error, and returns TRUE or FALSE. The logical and operator && returns TRUE SQRTPI: Returns the square root of (number * pi). EARLIER: Returns the value in the column prior to the specified number of table scans. ISINSCOPE: Returns true when the specified column is the level in a hierarchy of levels. FIXED: Rounds a number to the specified number of decimals and returns the result as text with optional commas. PATH: Returns a string that contains a delimited list of IDs, starting with the top/root of a hierarchy. ERROR: Raises a user specified error.