Forum Discussion

scaballerom's avatar
scaballerom
Helper I
3 years ago

DAX optimization

Hi all,   I have a table of about 2M records, with a column, task_starting_datetime (dd.mm.yyyy HH:mm:ss), which is my reference date. I need the specific time on the datetime, so it's hard to link...
sebouier's avatar
sebouier
Frequent Visitor
3 years ago
I have a table of about 2M records, with a column, task_starting_datetime (dd.mm.yyyy HH:mm:ss), which is my reference date. I need the specific time on the datetime, so it's hard to link it to a dimensional Calendar table.

Here's what you should do : 

 

By splitting your "task_starting_datetime" in one column "dates" and another column "times" in Power Query Editor, it will make your dataset faster to load. 

Then you can easily link your "task_starting_date" to the calendar/dates table.

Same for your "task_starting_time" linked to a "Times" table.

 

Btw, 

 

TimeKey = Times[Hour]*10000+Times[Minute]*100+Times[Second]

 

 

It should make the calculations easier.