Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
@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.
@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.
User | Count |
---|---|
25 | |
12 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
12 | |
11 | |
8 | |
7 |