sqldusty.com
#MDXMonday: Previous Year Month to Date Calculation | SQL with Dustin Ryan
https://sqldusty.com/2015/07/27/mdxmonday-previous-year-month-to-date-calculation
SQL with Dustin Ryan. MDXMonday: Previous Year Month to Date Calculation. July 27, 2015. I recently had a client give us a call asking for helping creating a calculation in her cube to show the month to date value for the previous year. Here’s the basics of the calculation I created. View last week’s #MDXMonday – Calculating Daily Average Sales. The Aggregate function to roll up the Internet Sales Amount for each day in a month. Member [Measures].[MTD Internet Sales] as. 0, Non Empty [ Date. 1, [ Date.