Adding a new column from another with specific cell values

We want to help you but your description is too vaugue. Please write it again clearly.

Provide example input data.

Also provide the example desired output, with a clear step-by-step description of any calcutations the process flow.

Try keep it simple and ask one question per ticket.
You will get a quick response if you put time, care and effort into writing clear problem descriptions.
Remember you are gerrting free expert help, so please put lots of proper effort to asking questions and providing example.

Vaugue descriptions can waste your time and ourtime.

Look foward to helping you when the above information is forthcoming

Hi ggfd ,

Please try this:
Here is my sample data:

Use this DAX to create a new column:

Fixed Value = 
SWITCH(
    TRUE(),
    'Table'[Product] = "B", 'Table'[Old Value] * 0.8,
    'Table'[Product] = "C" || 'Table'[Product] = "D", 'Table'[Old Value] * 0.65,
    'Table'[Old Value]
)

The final output is below:

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi ggfd,

you can achieve expected result in Power Query

If you add more Expected Revenue Columns then Fixed Expected Revenue columns will be added automatically.

Result:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("Tc9BC4JAEAXgvzII3URWY8lLh6B7QXUSDzaOZelszM4S/fuCzPb4YN7Hm6pK2EFH1J4bvEMnbgTiFjB4dSNJBtVxc9jmhTHrwi7qJE1Ohy18YmbMFPLUfGOdVklgHxDJ+y4MoOS150tkLIvZsLFR2FnYi7sRKmDDSMNAbbwhN2YGyhhY/oHd4+FEA/f6AhRqlFroGfRK8BT3mYNBhBhfMHVXNl7y/+XpOAXtRwJ1MDZyJ/0dlXlmy9//U6N+Aw==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Close Reason" = _t, #"Expected Revenue 2023" = _t, #"Expected Revenue 2024" = _t]),
    ChangedTypeRevenueDynamic = Table.TransformColumns(Source, List.Transform(List.Select(Table.ColumnNames(Source), each Text.Contains(_, "Revenue", Comparer.OrdinalIgnoreCase)),
      (colName)=> { colName, each Currency.From(Text.AfterDelimiter(_, " "), "en-US"), Currency.Type } )
  ),
    Ad_Percentage = Table.AddColumn(ChangedTypeRevenueDynamic, "Percentage", each Percentage.From(Text.BetweenDelimiters([Close Reason], "=", "]")), Percentage.Type),
    AddedFixedColumnsDynamic = List.Accumulate( 
    List.Select(Table.ColumnNames(Source), each Text.Contains(_, "Revenue", Comparer.OrdinalIgnoreCase)),
    Ad_Percentage,
    (s,c)=> Table.AddColumn(s, "Fixed " & c, each Record.Field(_, c) * (1 - [Percentage]), Currency.Type)
)
in
    AddedFixedColumnsDynamic

Hello dufoq3,
Thanks so much for your fast response. I aprreciate that.
However, is that M? I'm asking because the code works, but I would not know how to replicate or modify it in the future.
That's why I've been asking to get this help in Python, or even in DAX if python is too hard.
Thanks for the help again,

Ho, yes, its M. You can see my notes below how to use it.