Problem with creating new columns

[gianmarco]

Dear All,

I have the following db:

DocNum	RowNum	Discount%
A	1	30
A	1	5
A	2	15
A	2	15

Is there a way I can create two additional columns as follows?

DocNum	RowNum	Discount%	Discount1	Discount2
A	1	30	30	5
A	1	5	30	5
A	2	15	15	null
A	2	15	15	null

- When there are two distinct Discount%, count the former as Discount1 and the latter as Discount2

- When there is one distinct Discount%, count it only once as Discount1

Thank you for your help

[Jihwan_Kim · Accepted solution]

Link to the pbix file