Measuring pipeline over time

Question

Hello experts, hoping someone can help me. I'd like to be able to create a chart that shows the pipelines total value over time.&nbsp;&nbsp;For example, using the data below I woul expect...January 31 = 200 (Opp1+Opp2)February 29= 300 (Opp2+Opp3+Opp4)March 31=&nbsp; 300 (Opp3+Opp4+Opp5)April 30= 200 (Opp4+Opp5)May 31= 100 (Opp5 since it hasn't closed yet)&nbsp;IDValueCreated DateClosed Dateopp11001-Jan10-Febopp210015-Jan10-Maropp31001-Feb10-Apropp410015-Feb10-Mayopp51001-Mar&nbsp;&nbsp;Thanks in advanced!

greg_deckler · Answer

Open Tickets.&nbsp;https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/td-p/409364

anonymous · Answer

Thanks for the suggestion, but it doesn't seem to work for my data, and upon review that solution the numbers don't seem to add up to me unless I am counting incorrectly.

v-yuta-msft · Answer

Anonymous&nbsp;,
&nbsp;
Could you please clarify the logic why&nbsp;February 29= 200 (Opp2+Opp3), not&nbsp;February 29= 300 (Opp2+Opp3+Opp4)?
&nbsp;
Regards,
Jimmy Tao

anonymous · Answer

Sorry, my mistake, you're correct.

anonymous · Answer

Playing with this a little bit more I seem to have found a solution, but it's very slow and I am sure not the right way to go about this.&nbsp;What I did was create a measure for pipeline cumulative total by created date and another measure for pipeline cumultive total by closed date. Then I created another measure that subtracts the measures. It seems to work, but is pretty slow to calculate, so I am assumig it's not the "right" way to go about this.

Forum Discussion

Related content

Deployment Pipelines

pipelines

Scheduled pipelines failing

Deployment Pipelines

Fabric pipeline