Forum Discussion
Multiply value if a column value is X, otherwise keep it
Hi I have a small issue that hope someone here can help me with. I'm working with a simple excel table that contains sold items and how much discount we have given on each specific produkt. ...
Burningsuit
Resident Rockstar
Resident RockstarThis is best done in Power Query. In Power BI Desktop, go to "Transform Data" and add a custom column as below...
This will generate a new column "Unit Value" with the calculation you need.
Hope this helps
Stuart