Forum Discussion
Split values based on duplicate references
Hello I am trying to get the final sale (after discounts), but in my current table each sale that has more than one product the total discount of the sale is repeated on each line generating tha...
Here I add a screenshot of what I'm looking to do, basically I need to create a column in the data table (discount) in which the discount is divided by the number of products purchased by sale (code), so that in the end the sales table looks like in the following image
Hi,
You do not need to create a discount column for that. To your Table/matrix table visual, just drag The Reference field and write this measure to get the discount
Discount = min(Data[Sale discount])