Report Builder, convert year column from text to date

[juanriver202063]

I am building a report using a power bi data set. 

I have a column Calendar Year which is a Text field. 

I want to add a simple filter which states that all dates greater than 2014 should be in the report only. 

I can't seem to convert the text field to a date field so that this filter works. 

Is there any way to convert that text calendar year to a date so I can use it to filter data in paginated reports? 

[SamInogic]

Hi @juanriver202063 ,

You can try to convert Year column from text to date in order to achieve this you can follow below steps and Screenshot:

• Navigate to the Power query Editor and right click on "Calendar Year" text column.
• Click on Change Type and select Date option as shown in below screenshot.
  
  

This will result the data as follows:

If this answer helps, please mark it as Accepted Solution so it would help others to find the solution.

Thanks!

Inogic Professional Service Division

An expert technical extension for your techno-functional business needs

Power Platform/Dynamics 365 CRM

Drop an email at crm@inogic.com

Service:  http://www.inogic.com/services/ 

Power Platform/Dynamics 365 CRM Tips and Tricks:  http://www.inogic.com/blog/