Solved

Each date as individual row based on from and to dates

  • 19 February 2024
  • 1 reply
  • 23 views

Hi,

 

I am in the proces of migrating old Power BI managed data sources to our data warehouse in TimeXtender. However, in power query I use a function called List.Dates to create a row for each data between two dates. The data in this situation is sick days. Example below of what I need it to become:

 

Sickdatefrom SickdateTo Sickday
1-1-2024 3-1-2024 1-1-2024
1-1-2024 3-1-2024 2-1-2024

 

In summary: I need to be able to add the Sickday column in TimeXtender just like I do in Power Query. I couldn't find anything online related to this subject. I am reading all thsis data from a CSV file by the way.

icon

Best answer by Thomas Lind 19 February 2024, 10:48

View original

1 reply

Userlevel 6
Badge +5

Hi @r.depagter 

Do you need it before it goes into the DW instance or is it something that needs to be in place for the SSL instance?

If it is for the SSL instance you can create a custom view using the Date table to fill the dates between the start and stop date.

Like I explain in this old guide

https://legacysupport.timextender.com/hc/en-us/articles/115005972746-Improve-execution-times-by-splitting-exchange-rates-out-on-dates

Reply