Forum Discussion

vincetaylor's avatar
vincetaylor
Icon for Helper I rankHelper I
5 years ago
Solved

Display data for the past one year only

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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi vincetaylor ,

     

    You could simply use Relative date filter.

     

    Best Regards,

    Jay

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
5 years ago

vincetaylor 

maybe you can create a new column and filter that column

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