title: Create cube calculation in SSAS using MDX statement to allocate monthly target to daily level
body: <p>I have a cube fact table for targets, the targets are at the monthly level (Jan = 300, Feb = 450, Mar = 350 etc.)</p>
  
  <p>This is joined to the date dimension in my cube at using month as the join, however the dimensions grain is at the day level.</p>
  
  <p>What I want to do is create a calculation so that the monthly target is allocated evenly to the days in the month so each day in Jan has a target of 300/31 Feb 450/28 etc.</p>
  
  <p>I then want to be able to use this calculated measure as my target and have it available as the daily/monthly/quarterly/Annual Target.</p>
  
  <p>I think this should be possible with an MDX statement (or perhaps a few using a few calculated measures) but I'm not that familiar with it.</p>
  
  <p>So would this approach work and what would the mdx look like?</p>
  
  <p>Thanks</p>