Reply
GunnarStone
New Member

Question regarding date/time table

Hello,

 

I am very new to Power BI and I've encounterd a problem related to time/date convertion and relationship. I'm trying to make a calendar-table "dimKalender" for my sales-table "factSalg" with the relationship *:1. When I link the two different in the model view with "date" it appears as a 1:1 relationship. I have formated both date-related data into date/time, both in PowerQuery and in data view. 

 

The "dimKalender" is made with the following DAX-function:

 
dimKalender =
    Calendar
        (date   (year   (min    (factSalg[Dato])), 1,1),
        date    (year   (max    (factSalg[Dato])),12,31)
    )

I went into PowerQuery and removed the "time"-data on the "factSalg" which made the *:1 connection possible. 

 

Does anybody know how I can fix it so that the "time" is possible to keep, while I can sitll make the *:1 connection between the tables? 

 

Bilde 4.PNG

Bilde 1.PNG

Bilde 3.PNG

 

  

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

@GunnarStone Leave the original column in place and add a new column that truncates the time off? Then you make the relationship on the non-time data column but you still have the original column that includes the data and time.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

1 REPLY 1
Greg_Deckler
Super User
Super User

@GunnarStone Leave the original column in place and add a new column that truncates the time off? Then you make the relationship on the non-time data column but you still have the original column that includes the data and time.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)