Forum Discussion

Kolumam2810's avatar
Kolumam2810
New Member
5 years ago
Solved

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 achiev...
data protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    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]
    )
    RETURN
    CALCULATE (
    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

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
5 years ago

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]
)
RETURN
CALCULATE (
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