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 

sturlaws's avatar
sturlaws
Resident Rockstar
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 

ivostammis's avatar
ivostammis
Helper I
6 years ago

Thanks! I ended up generating the table in powerquery, as DAX was already slowing my model down a lot I hope this also contributes to refresh speed 🙂