Forum Discussion
Solved
conditional multiply
Hi all, I have a table which looks like the following UniqueID Sub Total OriginalDis NewDis NewRate 1 1a 500 10% 20% Total x NewDis per Unique ID 1 1b 50% 40% 1...
shei7141 here is the formula, add new column
New Col = CALCULATE ( MAX ( 'Table'[Total] ), ALLEXCEPT ( 'Table', 'Table'[UniqueID] ) ) * 'Table'[NewDis]I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
