Forum Discussion

JRive116's avatar
JRive116
Regular Visitor
11 months ago
Solved

Data Granularity

Hi everybody! I'm a rookie in PBi and need some help. I'm pulling 2 folders. Folder "A" has excel tables with minute increment flow measurement data for 12 months. Folder "B" has excel tables wit...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    10 months ago

    JRive116 I split your TableA date/time into a date and time columns. I then created a third table of distinct time values at the 10 minute increment level by doing this:

    Time Table = DISTINCT( 'TableA'[DATE_TIME "A".2] )

    Relate this to both of your tables to the time columns in each.

    Plot it like this:

     

     

     

JRive116's avatar
JRive116
Regular Visitor
10 months ago

Greg_Deckler 

I believe you did it!
I could not quite understand what AmiraBedh said but I appreciate your input as well!