Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

YTD Change Calculated Column

Hi, I have a table like below: Current Balance   as_of_date   deal   Price   Value   444 12/14/22 A 70 3 5674 12/14/22 A 50 5 279 12/14/22 A 60 8 .. 12/14/22 B 70 ...
Need Help
  • Bifinity_75's avatar
    Bifinity_75
    3 years ago

    Hi Anonymous , try this:

     

    - Create this calculate column:

    Concat = Table_[deal  ]&Table_[Price  ]


    - Create this another calculate column:

    Result = var min_p=CALCULATE(MAX(Table_[Value  ]),ALLEXCEPT(Table_,Table_[Concat]))
return
min_p-Table_[Value  ]

    The result:

     

     

    Best Regards

     

     

     

     

Bifinity_75's avatar
Bifinity_75
Solution Sage
3 years ago

Hi Anonymous , try this:

 

- Create this calculate column:

Concat = Table_[deal  ]&Table_[Price  ]


- Create this another calculate column:

Result = var min_p=CALCULATE(MAX(Table_[Value  ]),ALLEXCEPT(Table_,Table_[Concat]))
return
min_p-Table_[Value  ]

The result:

 

 

Best Regards