Forum Discussion
Helper ICompare yearly data from one date column
Community ChampionYou can use the data as is, but best practice is to load your data without the year and month columns and then add a calendar table. I have an article about calendar tables here http://exceleratorbi.com.au/power-pivot-calendar-tables/
when you say you want 3 columns, what do you mean?
- elatreille
Hi Matt,
This is what I did and forgot to mention.
But still don't see how to use the date column and display the data in one chart with 3 column for the 3 years period.
- MattAllington
The problem is that your date column only contains the date. You need a year column to do what you want to do. Once you have a year column, you can put the year on the ledgened and filter for the years you want in the chart.
Take a look at my article on calendar tables in my knowledge base here http://exceleratorbi.com.au/power-pivot-calendar-tables/
