Forum Discussion

juanriver202063's avatar
juanriver202063
New Member
3 years ago

Report Builder, convert year column from text to date

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? 

@paginated report
@paginatedreport
Paginated Report Builder

1 Reply

  • SamInogic's avatar
    SamInogic
    Super User
    3 years ago

    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/