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

  • Niko's avatar
    Niko
    Frequent Visitor
    9 years ago

    Hi Anonymous

     

    Thank you for reply Martin. I tried this and it comes with an error "A date column containing duplicate dates was specified in the call to function 'FIRSTDATE'. This is not supported."

     

    I tried this with both data types date and date/time and it didn't make any difference.

     

    Br. Niko

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hi Niko

       

      Thank you for the reply. It doesn't matter what date-format you use. I would recommend always using Date/Time if time stamps matters.

       

      A question: Is there any particular reason for having duplicates on dates? I might have a solution here depending on your answer.

      • Niko's avatar
        Niko
        Frequent Visitor
        9 years ago

        Anonymous there is no reason to have duplicates on dates. Data just turned up this way when I formated epoch time to human readable time. Time stamp matters in this case, cause I want to drill down to minute level.

         

        Br. Niko