Skip to Main Content

Analytics Software

Margin % or YOY Change % on a year-to-date measure

Daniel RuettigerSep 19 2022

Hello I am having a difficult time trying to determine how to create a member that calculates the Margin % or YOY Change % on a Year-to-date mdx measure in my ASO cube. The issue is that the formula calculates the MTD % and then sums each month, instead of calculating the YTD $ / YTD $. I attempted to use IFF statements in my member formulas, however, I continue to get errors when trying to use MDX functions in members saying that the member function is not recognized. Anyone know how to solve this issue or what the standard practice for creating these calculations?