Forum Discussion

ggfd's avatar
ggfd
New Member
2 years ago
Solved

Adding a new column from another with specific cell values

Hello group, I have a spreadsheet column with incorrect values. However, there's no "one size fits all". In other words, I cannot apply a reduction of 25% to the entire column, as some cells are cor...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi ggfd ,

    You can achieve this in DAX easily if your data can be transformed into this:

    The data types of all columns except the first are Decimal number.
    You can use these DAXs to create two new columns:

    Fixed Expected Revenue 2023 = 'Table'[Expected Revenue 2023 (PowerBI column Type: decimal number)] * (1 - 'Table'[TASD1200])
    Fixed Expected Revenue 2024 = 'Table'[Expected Revenue 2024 (PowerBI column Type: decimal number)] * (1 - 'Table'[TASD1200])

    The final output is as 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.

speedramps's avatar
speedramps
Super User
2 years ago

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