Running Total Measure

[Anonymous]

I am trying to get some result like this:

quarters since flagged->	1	2	3	4	5	6	7	8
Quarter 3'2014	6.3%	6.3%	6.3%	6.3%	6.3%	6.3%	6.3%	6.3%
Quarter 4'2014	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%
Quarter 1'2015	0.7%	1.5%	1.5%	1.5%	1.5%	1.5%
Quarter 2'2015	5.7%	7.2%	7.7%	8.6%	8.6%
Quarter 3'2015	6.6%	10.1%	10.4%	11.1%
Quarter 4'2015	9.4%	13.2%	13.9%
Quarter 1'2016	16.5%	21.2%
Quarter 2'2016	16.8%

I have tried using running total quick measure but wherever the "quarter since flagged" is missing, I am getting holes in my output. Please suggest a better way to achieve this.

[v-juanli-msft]

Hi @Anonymous 

Please provide your orginal data structure and the rule to achieve final output so i can work for your scenario.

Best Regards

Maggie