Customising Dates

Hi Helen,

Thank you for the forum question.

You will need to convert the 201908 to a date.

In Data view add a column to the table and in the formula bar write:

Date = DATE(left([header of the column where you have 201908 stored],4),right([header of the column where you have 201908 stored],2),1)

If you use the new column for the x axis of the chart you should be able to get the chart you want.

To get the last 12 month values in the chart:

Add a new column and type:

Last12 =IF('Date'[Date] <= EOMONTH ( NOW (); -12 )||'Date'[Date]>= EOMONTH ( NOW (); 0 ),FALSE,tRUE)

Where 'Date'[Date] is the primary key from your date table.

Add the column to the filter of the chart and the chart will always show the last 12 month.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector