Failing to us a time table as dimension

[chris2]

Hi,

I am trying to follow this https://radacad.com/how-to-use-time-and-date-dimensions-in-a-power-bi-model

I created a dim_time and a dim_date table and corrospondig realtionships to my fact table as described in the blog. 

The relationship with the dim_date table works as expected. 

However the relationship with the dim_time table does not work correctly. Somhow no all times are matched to each other.

I checked:

• Datatype of both times
• direction of relationship (1:n) : dim_time -> fact_time
• relationship is active

Anyone any idea how to fix this problem?

Many thanks in adavance!

[RicoZhou2]

Hi @chris2 ,

If there is a dimtime matching facttime, data in dimtime won't show blank.

My Sample:

DimDate:

DimDate = CALENDARAUTO() 

DimTime:

let
    Source = List.Times(#time(0,0,0),24*60*60,#duration(0,0,0,1)),
    #"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    #"Renamed Columns" = Table.RenameColumns(#"Converted to Table",{{"Column1", "Time"}}),
    #"Changed Type" = Table.TransformColumnTypes(#"Renamed Columns",{{"Time", type time}})
in
    #"Changed Type"

Relationship:

Result is as below.

Best Regards.

[chris2]

Hi @RicoZhou2 ,

thank you for your reponse. You basically described what I did. The only difference is that I get blank times on both the fact and the dim side.