- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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:
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?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@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...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@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...

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
05-15-2024 12:09 AM | |||
Anonymous
| 07-29-2024 08:39 AM | ||
01-10-2024 10:10 PM | |||
11-17-2022 01:37 AM | |||
07-24-2024 04:56 AM |
User | Count |
---|---|
14 | |
14 | |
11 | |
11 | |
8 |