MDX WITH statement

MDX WithStatement

WITH {[PRODUCT GEO]} AS
{[PRODUCT EAST],[PRODUCT WEST]}
SELECT {[PRODUCT EAST],[PRODUCT WEST]} ON COLUMNS,
[YEAR].MEMBERS ON ROWS
FROM [PRODUCT CUBE]
WHERE [MEASURES].[TOTAL PRODUCT]

MDX WITH statement was last modified: October 1st, 2017 by Justin Antony

DAX Switch Statement

DAX Switch Statement
ShirtSize := SWITCH (Dimprd[size],
“S”,”Small”,
“M”,”Medium”,
“L”,”Large”,
“N/A”
)

DAX Switch Statement was last modified: October 1st, 2017 by Justin Antony