Report Builder, convert year column from text to date

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 [email protected]

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

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