Forum Discussion
PushkarP
Helper I
Helper IIncremental 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
- 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
Community Champion
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.
PushkarPThanks for suggestion, I created a new column for incremental referesh.