How to repeat a column n number of times

[VaibhavNath]

Proj	A1	A2	A3
PRJ1	10%	20%	10%
PRJ2	5%	5%	3%
PRJ3	5%	4%	5%
PRJ5	5%	5%	6%
PRJ6	5%	5%	5%
PRJ7	3%	5%	5%
PRJ8	10%	1%	20%

Proj	A1 duration(no of months)	A2 duration(no of months)	A3 duration(no of months)
PRJ1	4	4	4
PRJ2	3	4	5
PRJ3	3	3	6
PRJ5	5	4	3
PRJ6	5	4	3
PRJ7	5	4	3
PRJ8	5	5	2

Output table:

	Jan	Feb	Mar	Apr	May	June	July	August	September	October	November	December
PRJ1	10%	10%	10%	10%	20%	20%	20%	20%	10%	10%	10%	10%
PRJ2	5%	5%	5%	5%	5%	5%	5%	3%	3%	3%	3%	3%
PRJ3	5%	5%	5%	4%	4%	4%	5%	5%	5%	5%	5%	5%
PRJ5
PRJ6
PRJ7
PRJ8

Hey,

Could anybody please help me on this. First two above tables are input & third one is the output table. First table contains the efficiency parameters phasewise(A1,A2,A3) for the project. Second table mentions the duration (in no of months of for each project). Output would be in form of third table where efficiency values are repeatedas per the duration mentioned in 2nd table. for e,g(in output table) for PRJ1, A1 value is repeated 4 times as the duration of A1 phase(in 2nd table) is 4. Then A2 value is repeated 4 times as it is also mentioned as 4 in second table. likewise for others.

[Anonymous]

Hi @VaibhavNath ,

With the logic of DAX, it is not achievable at this time. Can only be achieved manually.

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[VaibhavNath · Accepted solution]

Thanks for the confirmation, I also was not able to find anything else. Have written a script in excel to automate this