Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Incremental refresh with ID (YYYYMMDD)

Hi all   I wanted to try incremental refresh but got stuck since we use IDs for date related columns in our warehouse. I can't use the ID for the filtering with the two parameters RangeStart and Ra...
Need Help
  • Stachu's avatar
    Stachu
    8 years ago

    basically you need to apply filter on IdDay, based on RangeStart & RangeEnd parameters
    sample syntax:

    =Table.SelectRows(#"Changed Type", each [IdDay] >= Date.Year(RangeStart)*10000+Date.Month(RangeStart)*100+Date.Day(RangeStart) and [IdDay] < Date.Year(RangeEnd)*10000+Date.Month(RangeEnd)*100+Date.Day(RangeEnd))
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Great! Now I got it to work.
Had to make sure the formula bar was actually enabled, otherwise there is no way to enter a formula.

Thanks for the help!

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hello

I understand how you use the non date field to put the filters in your Power Query and filter the data as per 2 parameters.

However, once you apply your changes and enable Incremental Refresh for your table, it does expect a datetime field, isn' it?

How did you handle that?

 

Regards