January 31, 2023
Hi,
I need help I have headers that are dates. I would like all the dates in one column, and would even like to be able to have years and months in there own column as well. I have tried to do this in PQ but having a little trouble. My headers currently are Partner, Region, Market, then header dates 1/1/2023, 2/1/2023 etc. I am trying to make awesome pivot tables showing performance measures and not successful. Please assist.
Moderators
January 31, 2022
Hi,
In PQ, first unpivot your data table. Select the Partner, Region and Market columns. Then "unpivot other columns". You'll end up with a much longer table, but with only 5 columns. The three you already had plus two extra. One is called Attribute (holding the dates). The other is called Value (holding the measures). Rename these as you like. Make sure you set the data type to Date for the date column.
When you then create a pivot table Excel should automatically add date intelligence that allows you to work with Years, Quarters and Months.
Should you get stuck, please come back here.
1 Guest(s)