Quick Measure Calc on a Measure

[murphm6]

Hi everyone,

I'm familiar with the new Quick Measures Preview feature. However, I haven't been able to figure out one item.

I'm building a scheduling and capacity planning dashboard. In this dashboard, I've created a measure representing machine capacity (say 100,000 units). And I have a date field representing when units are due to ship. What I'd like to represent is cumulative capacity over a certain set of ship dates (e.g. 100k units day one, 200k units day two, etc.). 

Right now, I have successfully created a measure showing cumulative demand, but I can't get the cumulative capacity to work. It only shows 100k units for each day.

Any suggestions?

[MFelix · Accepted solution]

Hi @murphm6,

I don't know how you made your machine capacity but if this is calcculated at a day level it will givee the 100k always maybe you need to.change it to multiply by the number of day you are looking so if you add your measure.to the 1st day of the month it will give 100k but if.its the 5th day.it.will be 5*100k.

Regards,
MFelix

[murphm6]

@MFelix great idea! I'll give it a try when I get back to my desktop and will respond back with the results.