Forum Discussion
Solved
Total rows into a column using formula
Hi Team, I have two columns : Columns 1 is Week (Wk1, Wk2, Wk3, Wk4, Wk5) Columns 2 has totals (100, 200, 400, 500, 100) I need to create columns for each Week, eg. Wk1 will the third columns w...
Hi Georgesunil77 ,
Is this result you want to achieve?
If it is, you can consider adopting my approach.
1.This is an initial table with the same data as yours:
2.I copied the two columns:
3.Select the two duplicate columns, and then click "pivot column" at the top.
4.Finally, I get this table as the result shows.
I hope my process will be helpful to you.
Best regards,
Community Support Team Selina zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Georgesunil77 , If the week name is not is sortable form then create a new column
Week Num = right([Column 1], len([Column 1]) -2)
then create a new column=
sumx(filter(Table, Table[week num] < = earlier(Table[week Num]) ) , [Column 2])