immediate if function (IIF) [IIF]

Share This

“A DMX function used in SQL Server cubes to return values based on a condition. Useful for setting colors or creating categorical data. For example, color properties can be set using IIF([Measures]. [Discount] > 2000, 255, 0). The function has three parameters: 1) the condition, 2) the value to return if the condition is true, and 3) the value to return if the condition is false.”

« Back to Glossary Index Download Tooltip Pro
By |February 1st, 2019|Comments Off on immediate if function (IIF) [IIF]