Pivot table

[kiran123]

Hi I need a help In Pivot table in power bi we can use the matrix for pivot but in my scenario 

I have three columns called "Atrribute","excess quentity","sum_of not fullfilled" and "Reposition Qty" reposition qty is nothing but the i want MINIMUM of (excess quentity and not fullfilled).

in matrix attribute column is pivot. 

so when i have added attribute and excess qty in rows and "sum_of not fullfilled" is in values. but in this when there is a sigle record in atrribute it is showing correct minimum qty for reposition qty but when there are multiple values for attribute  column its shows wrong minimum qty for reposition qty

I need the excel based pivote table where after pivote i can add a column where i can write min(column1,column2) so that i can get minimum values for the two column afterpivoted in new column.

For more details see the attachment

I have attached the imges please check 

i need the output like excel sheet data which output is Repo qty which the formula given to Repo column is MIN(excess quantity,sum of notfullfilled)

same condition is used for the matrix but the output for some columns is right but for some its shows wrong MIN values

[v-xicai · Accepted solution]

Hi @kiran123 ,

For the column formula "MIN([excess quantity], [sum of notfullfilled])" , if there are one or more measures in the arguments of MIN function, it will return wrong result. As a workaround, you may convert the measures into calculated columns, for example, create the [sum of notfullfilled] using calculated column.

Best Regards,

Amy

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.