SAMCRO2014
Board Regular
- Joined
- Sep 3, 2015
- Messages
- 158
I am trying to figure out if you can loop through data in the table in power query. Here is my scenario. I have employees who receive a bilingual bonus (BB). This amount gets charged to a cost centre for a specific time frame. The issue comes into play when the BB is charged to two or more CCs for the same time period. I need to be able to do a count of sorts so I can divide the cost evenly over the multiple cost centre for the specific time frame.
I was hoping to create a conditional column with results that show the "Count" column as per below:
<colgroup><col><col><col span="2"><col><col></colgroup><tbody>
</tbody>
<colgroup><col><col><col span="2"><col><col></colgroup><tbody>
</tbody>
I was hoping to create a conditional column with results that show the "Count" column as per below:
CC | EE # | Start Date | End Date | BB | Count |
120544320 | 1111111 | 2019-04-01 | 2019-06-26 | Yes | 1 |
120544320 | 1111111 | 2019-06-27 | 2019-07-19 | Yes | 1 |
120147200 | 9999999 | 2019-04-01 | 2019-05-03 | Yes | 3 |
120147204 | 9999999 | 2019-04-01 | 2019-05-03 | Yes | 3 |
120147203 | 9999999 | 2019-04-01 | 2019-05-03 | Yes | 3 |
120147200 | 9999999 | 2019-05-04 | 2019-05-24 | Yes | 3 |
120147203 | 9999999 | 2019-05-04 | 2019-05-24 | Yes | 3 |
120147204 | 9999999 | 2019-05-04 | 2019-05-24 | Yes | 3 |
120147203 | 9999999 | 2019-05-25 | 2019-07-19 | Yes | 2 |
120147204 | 9999999 | 2019-05-25 | 2019-07-19 | Yes | 2 |
<colgroup><col><col><col span="2"><col><col></colgroup><tbody>
</tbody>
Is this even possible in Power Query? | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
<colgroup><col><col><col span="2"><col><col></colgroup><tbody> </tbody> |
<colgroup><col><col><col span="2"><col><col></colgroup><tbody>
</tbody>