Forum Discussion

Niko's avatar
Niko
Frequent Visitor
9 years ago

Creating DateTime relationship, epoch time

Hi,   I'm new to powerBI and I just pulled my historical weatherstation data from Azure to powerBI and now I'm trying to figure out how to make DateTime relation. Data was orginally organized by ep...
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Niko

 

I suggest you try a different method for creating your date-table. Try creating your date table like this:

 

Go to menu -> press new table -> insert this dax query: TimeDim = CALENDAR(FIRSTDATE(Table[Date]); LASTDATE(Table[Date])) -> press enter -> go to relationships tab on the left -> create the relation between your tables.

 

I can go into details about how it works. Let me know if you want me to elaborate on it. For now, try this method.

 

Best

Martin