Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

New column need based percentage increased

Hi,

 

Please help me on the below logic 🙂

 

I need "Cumulation Inflation" colunn based on column "D" calculation.

 

Thanks in Advance 🙂

@amitchandak , @daXtreme @Greg_Deckler @Fowmy @tamerj1 @Jihwan_Kim 

 

Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    Hi,

    One of ways to solve this problem (creating a recursive-type column) is creating a function in Power Query Editor.

     

    Please check the below picture and the attached pbix file.

     

    In a blank query, create a function like below.

    (x as number) as number =>
let
    _result = function(x-1)*0.01 + function(x-1)
in
    if x = 2023 then 1.0100 else _result

     

     

    And then, add a new column into the table by invoking custom function that is created above.

     

     

2 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Icon for Super User rankSuper User
    3 years ago

    Hi,

    One of ways to solve this problem (creating a recursive-type column) is creating a function in Power Query Editor.

     

    Please check the below picture and the attached pbix file.

     

    In a blank query, create a function like below.

    (x as number) as number =>
let
    _result = function(x-1)*0.01 + function(x-1)
in
    if x = 2023 then 1.0100 else _result

     

     

    And then, add a new column into the table by invoking custom function that is created above.