Forum Discussion

kiran123's avatar
kiran123
Frequent Visitor
6 years ago
Solved

Pivot table

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"...
Need Help
  • v-xicai's avatar
    v-xicai
    6 years ago

    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.

v-xicai's avatar
v-xicai
Community Support
6 years ago

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.