Forum Discussion
Column Calculation
I want to calculate Percentage 2 column from the percentage columns based on the Group A. For example the Percentage 2 first row (1.97) is fetched from the Percentage second row (1.97). How to achieve the same?
| Group | Start Date | End Date | Percentage | Percentage 2 |
| A | 31/12/2020 | 29/06/2021 | 1.36 | 1.97 |
| A | 30/06/2021 | 30/12/2021 | 1.97 | 4.05 |
| A | 31/12/2021 | 29/06/2022 | 4.05 | 4.02 |
| A | 30/06/2022 | 30/12/2022 | 4.02 | 4.2 |
| A | 31/12/2022 | 29/06/2023 | 4.2 | 4.17 |
| A | 30/06/2023 | 30/12/2023 | 4.17 | 4.36 |
| A | 31/12/2023 | 29/06/2024 | 4.36 | 4.36 |
| A | 30/06/2024 | 30/12/2024 | 4.36 | 4.53 |
| A | 31/12/2024 | 02/06/2025 | 4.53 | 66.98 |
| A | 03/06/2025 | 03/06/2025 | 66.98 | 0 |
Hi, Kolumam2810
Please check the below for creating a new column.
Percentage 2 CC =VAR currentgroup = 'Table'[Group]VAR nextstartdate =MINX (FILTER ('Table','Table'[Start Date] > EARLIER ( 'Table'[Start Date] )&& 'Table'[Group] = currentgroup),'Table'[Start Date])RETURNCALCULATE (SUM ( 'Table'[Percentage] ),FILTER ('Table','Table'[Start Date] = nextstartdate&& 'Table'[Group] = currentgroup))Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
1 Reply
Hi, Kolumam2810
Please check the below for creating a new column.
Percentage 2 CC =VAR currentgroup = 'Table'[Group]VAR nextstartdate =MINX (FILTER ('Table','Table'[Start Date] > EARLIER ( 'Table'[Start Date] )&& 'Table'[Group] = currentgroup),'Table'[Start Date])RETURNCALCULATE (SUM ( 'Table'[Percentage] ),FILTER ('Table','Table'[Start Date] = nextstartdate&& 'Table'[Group] = currentgroup))Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM