Forum Discussion

elatreille's avatar
elatreille
Icon for Helper I rankHelper I
10 years ago

Compare yearly data from one date column

Hi guys,   I have a sheet with actually 5 columns 1. Office 2. Year of sale (ex:2014 in a text format) 3. Month of sale (ex: January in a text format) 4. Number of sale 5. Date (date format) ...
Need Help
elatreille's avatar
elatreille
Icon for Helper I rankHelper I
10 years ago

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's avatar
MattAllington
Icon for Community Champion rankCommunity Champion
10 years ago

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/