CODEWITHSUNDEEP
excelpivot-tablepowerquery
datalyn
datalyn

Reputation: 15

Excel pivot table loses max & min columns on refresh

I have a pivot table built on a data model fed by a power query. There are 3 columns based on the 'date period' field - max of date period, min of date period, and distinct count of date period. When the power query & pivot table are refreshed, the max & min columns disappear, but the distinct count column remains.

I've not been able to pin down what changes in the data trigger this - it's when additional rows are added to the data source, but not all additions result in the columns disappearing.

Any suggestions for where I can look next to resolve this?

Upvotes: 0

Views: 178

Answers (1)

SaraBear
SaraBear

Reputation: 1

Update: My solution below worked for a bit, and then my min/max date columns started disappearing again when the data model was updated. Ugh.

I ran into this issue today, and found a fix. When I initially dropped the date column into the pivot, Excel automatically generated additional date fields named similarly and broken down by (Year), (Qtr), (Month). When I deleted the additional (Year), (Qtr), (Month) fields from the data model, my pivot min_date and max_date columns did not disappear and updated as expected.

Upvotes: 0

Related Questions