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
    11 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:

     

     

     

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
11 months ago

JRive116 Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.