Forum Discussion

ivostammis's avatar
ivostammis
Helper I
6 years ago
Solved

Generateseries: unexpected behaviour

I am building a maintable containing a long series of points in time. This maintable looks up / checks values from other tables which are not continuous (so containing gaps in time). To populate this...
  • sturlaws's avatar
    sturlaws
    6 years ago

    Hi ivostammis,

     

    I tried different variations of your table, and I experience the same issue as you. And I can't get it to work properly. Funny thing is that when I create new calculated column like this:

    Date time column = DATEVALUE([Value])+TIMEVALUE([Value])

    it returns the correct values. So that is one possible workaround. Another workaround would be to create the datetime-list with Power Query. Using Power Query is usually beneficial for how Power BI treats your table. Here is a recipe for how to create the table in power query:
    http://datacornering.com/how-to-generate-date-and-time-interval-list-using-power-query/

    Cheers,
    Sturla 

lbendlin's avatar
lbendlin
Super User
6 years ago

i think your floating point hunch is still correct.

 

Instead of cumulatively adding ten seconds, I would use a fixed datetime starting point and calculate the offsets from there. That way you can avoid the drift.