Good morning,
My dilemma:
I have a spreadsheet that roughly looks like the one below. IT refreshes that file every week with an additional week of data.
<tbody>
</tbody>
My goal:
I want my Power Query model to SUM all columns EXCEPT for DoorID and CustName (I really have a couple more columns to exclude), so that as the weeks keep piling on, I can refresh the query to include the last weeks that were just inserted by IT. Is there a way to do this?
I am not unpivoting the columns because otherwise the data range gets way to big - I mean over 20MM rows. It takes too long to refresh.
Thank you!
My dilemma:
I have a spreadsheet that roughly looks like the one below. IT refreshes that file every week with an additional week of data.
DoorID | CustName | January Week 1 | January Week 2 | January Week 4 | February Week 1 | February Week 2 | ..... |
12345 | Macy's | 10 | 13 | 20 | 2 | 9 | ..... |
4578 | Saks | 23 | 43 | 11 | 72 | 7 | ..... |
<tbody>
</tbody>
My goal:
I want my Power Query model to SUM all columns EXCEPT for DoorID and CustName (I really have a couple more columns to exclude), so that as the weeks keep piling on, I can refresh the query to include the last weeks that were just inserted by IT. Is there a way to do this?
I am not unpivoting the columns because otherwise the data range gets way to big - I mean over 20MM rows. It takes too long to refresh.
Thank you!