Calculated Column: Add Number to Rows before

[Martin_Z]

Hello together,

I have a table with multiple projects in it. Each project has multiple steps and a few milestones. An example table could look like this:

Number	Project	Description
1	Project 1	Step 1
2	Project 1	Step 2
3	Project 1	Milestone 1
1	Project 2	Step 1
2	Project 2	Step 2
3	Project 2	Step 3
4	Project 2	Milestone 1

I want to create a calculated column that searches for the number the milestone has in the table and that writes that number to all rows in the specific project. The column I want to achieve should look like this: 

Number	Project	Description	Column
1	Project 1	Step 1	3
2	Project 1	Step 2	3
3	Project 1	Milestone 1	3
1	Project 2	Step 1	7
2	Project 2	Step 2	7
3	Project 2	Step 3	7
4	Project 2	Milestone 1	7

I somehow manged to do it with a measure, but that does not allow me to filter after the Milestone numbers, so it did not help me alot.

Is there any way to do it? Any help is very appreciated as I am a real beginner on that topic! 🙂

Best regards

Martin

[Ahmedx · Accepted solution]

1) you need to create an index column in power query

2) create a calculated column

[Martin_Z]

Hey Ahmedx,

thank you very much! That worked for me. 🙂

Best Regards

Martin

[Ahmedx]

explain how you got the sum of 3 and 7