Display data for the past one year only

[vincetaylor]

Hi all 

I have a table called List of Items. I also have a column called "Creation Date". i.e. the date each item was created. 
I only want to display the last year worth of data on a column chart i.e. Today() - 365

But my bar chart is showing all the data from 2016. 

Question: How do I get the chart to show only data for the past one year 

I would appreciate help with this issue.

[v-jayw-msft · Accepted solution]

Hi @vincetaylor ,

You could simply use Relative date filter.

Best Regards,

Jay

[ryan_mayu]

@vincetaylor 

maybe you can create a new column and filter that column

Column = if('Table'[creation]>today()-365,"Yes")

[Greg_Deckler]

@vincetaylor Perhaps:

Measure =
  VAR __Today = TODAY()
  VAR __EarliestDate = __Today - 365
  VAR __Date = MAX('Table'[Date])
RETURN
  IF(__Date >= __EarliestDate && __Date <= __Today,<some calculation>,BLANK())

[vincetaylor]

Hi @Greg_Deckler 

Can you please clarify what is meant by the text "<some calculation>" in the last row of your solution? 

[Greg_Deckler]

@vincetaylor That's where you would calculate something. I can't tell from your message and visual what calculation you are doing for you Value in your clustered column chart but whatever it is goes there. If you already have a measure for that, just plug the measure in for <some calculation>.