Data Granularity

Hello !

Thank you for posting on MS Fabric community.

Keep 2 separate tables and both should be pointing to a unique minute level time table so you need to build a time table at minute grain for your 12 months 

Time =
VAR Start = MINX(ALL(FactMinute), FactMinute[DateTime])
VAR End   = MAXX(ALL(FactMinute), FactMinute[DateTime])
RETURN
ADDCOLUMNS(
    CALENDAR(Start, End),
    "MinuteStamp",
     [Date]
)

and in both fact tables you need to have a key column that matches the time table minute stamp.

For the minute fact you can use the minute date time and for the hourly fact you can create HourStart = DATETIME(Date, Hour, 0, 0) so it matches the time table at the exact hour.

Your relationships should be :

• Time[DateTime] (unique) : one-to-many to MinuteFact[DateTime]

• Time[DateTime] (unique) : one-to-many to HourFact[HourStart]

Both relationships can be active.

Then create your measures.

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.

Sample data

Expected output (hopefully without the steps)
Dark Blue is "B"
Light Blue is "A"

I want to be able to plot, in one visual, in a contiuous manner both lines. Currently is Sums up all of the values per point. I dont really have a clear answer as to how to get from 2 to 3. :S 
Greg_Deckler 

Greg_Deckler 

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