Forum Discussion
tkramer
Advocate I
Advocate IRelationship of Time dimension table and FACT SQL table not connecting correctly
I have an issue with my Time Dimension table in my SQL reports. I am relating "Time" in the Dimension table to the "CreateTime" in the Fact table. When I use any of the fields from the Time dimensi...
tkramerAdvocate I
Advocate IGreat! That makes sense. I saw you used the TIMEVALUE funciton in DAX to create the column, but is there a way I could do this in Power Query without having milliseconds??
I don't see milliseconds in the Time column in Power Query, so I'm not sure how to remove them.
In my actual published report, I settled for creating a DAX Time column from each Timestamp from SQL in my tables. It works, but I am wanting to do everything in Power Query if I can for simplicity. It seems like the DAX created columns all connect perfectly, but using the columns with Extracting/Inserting Time in Power Query do not suffice.
Thank you Ibendlin
