Forum Discussion

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

Incremental refresh on a column with 'date' format

Hello,

I am trying to configure incremental refresh on a table. I have configured 'RangeStart' and 'RangeEnd' parameters. Now I want to apply filter using these parameters on a Column named 'Sent date' which is of date format, so I am unable to apply the filters. What do I need to do? Please note the column 'Sent date' has relationship with another table hence I cannot change its format to datetime in Power Query.

 

Thank you in anticipation.

Regards,

Pushkar

Need Help
Tips and Tricks
  • AllisonKennedy's avatar
    AllisonKennedy
    5 years ago
    Duplicate the column and set the data type of the new column and use that for your incremental refresh.
    As a side note/bonus, I typically use a DateKey in the format "yyyyMMdd" as my column to use for relationships with Date table.

2 Replies

  • AllisonKennedy's avatar
    AllisonKennedy
    Icon for Community Champion rankCommunity Champion
    5 years ago
    Duplicate the column and set the data type of the new column and use that for your incremental refresh.
    As a side note/bonus, I typically use a DateKey in the format "yyyyMMdd" as my column to use for relationships with Date table.