Accumulated total - show sequence of numbers added

[Anonymous]

Hi there,

I've built a table that features a "Creator" name and a distinct count of pieces created by the "Creator". As part of the competition I'm running, I give each "Creator" a raffle ticket for every piece they create.

I need to create the column "Raffle Ticket #s", which works like a running / accumulated total. Has anyone got a clue how I'd do this? Showing e.g. Adam Walford = "10-12" is preferred but not 100% necessary, so Adam Walford = "12" would be sufficient.    

 

Kind regards,

Jordan 

[Anonymous · Accepted solution]

Hi @Anonymous ,

Based on your description, you can do some steps as follows.

1. create an index column in Power Query Editor.

2. create a column.

Raffle Ticket #s = 

var x1=SUMX(FILTER(ALL('Creation'),[Index]<=EARLIER('Creation'[Index])),[# of pieces Created])

var x2=SUMX(FILTER(ALL('Creation'),[Index]<=EARLIER('Creation'[Index])-1),[# of pieces Created])

return

IF([Index]=1,1,1+x2)&"-"&x1

Result:

Hope that's what you were looking for.

Best Regards,

Yuna

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

[Jihwan_Kim]

Hi,

Please correct me if I wrongly understood.

Is it ok with you to show me more information about creators?

For instance, it would be very much helpful if I can know the index number of each creator. Or, do you have any rules that set the order of creators? Or, Can I re-arrange the order of creators by "# of pieces created"?

If I can know one or some of the above information, I think I can try to create "Raffle Tickets #s"

Thank you.