- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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" 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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
05-21-2024 04:55 AM | |||
06-23-2024 10:46 AM | |||
08-21-2024 02:53 AM | |||
08-29-2018 03:03 PM | |||
05-14-2024 06:23 AM |
User | Count |
---|---|
49 | |
33 | |
32 | |
27 | |
23 |
User | Count |
---|---|
40 | |
33 | |
19 | |
18 | |
16 |