Forum Discussion

QRS_04's avatar
QRS_04
New Member
8 years ago
Solved

Need help-filtering by year

Hello,    I need help filtering some data by year. The problem is that there isn't a date value in the data set I have, its just value columns with their year in the column heade name, i.e:    20...
  • v-piga-msft's avatar
    v-piga-msft
    8 years ago

    Hi  QRS_04,

     

    If I understand your sceanrio correctly that you have a column with the values like below and you need a year column to filter your data?

     

    2015 number of customers

    2016 number of customers

    2015 total sales

    2016 total sales 

     

    If it is, you could get the year by spliting your raw column in Query Editor.

     

     

    Then you could change the year column to be date type.

     

    Best Regards,

    Cherry

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
8 years ago

Hi  QRS_04,

 

If I understand your sceanrio correctly that you have a column with the values like below and you need a year column to filter your data?

 

2015 number of customers

2016 number of customers

2015 total sales

2016 total sales 

 

If it is, you could get the year by spliting your raw column in Query Editor.

 

 

Then you could change the year column to be date type.

 

Best Regards,

Cherry

QRS_04's avatar
QRS_04
New Member
8 years ago

Thanks for your help, Cherry!