Forum Discussion
calculating in QUERY excel
Query excel
INeed help calculating in QUERY.
I want to calculate a column that will give me a planned production quantity for the shift.
I have the possible/maximum output in each shift. And I have total demand.
The goal is to split the demand into shifts.. possible between 1-3 shifts.
(In Excel the calculation simply activates a reduction).
Thanks
sefi
2 Replies
Please provide sanitized sample data that fully covers your issue.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523Hi sef ,
I guess that you want to use groupby feature in Power Query, please kindly refer to
Grouping or summarizing rows - Power Query | Microsoft Learn
In Power Query, you can group values in various rows into a single value by grouping the rows according to the values in one or more columns. You can choose from two types of grouping operations:
-
Column groupings.
-
Row groupings.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
-
