- 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

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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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-...
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/1447523

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
10-26-2024 06:29 AM | |||
06-25-2024 03:02 PM | |||
10-09-2024 02:21 PM | |||
07-27-2024 09:33 AM | |||
10-10-2024 05:37 AM |
User | Count |
---|---|
33 | |
18 | |
14 | |
11 | |
10 |