Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All
I have a date table that looks like this:
And I have another table that has a date column like this:
I believe the reason I am unable to create relationship between this 2 column is because the time behind is different.
Please advise how can I work around this? I am only looking at the dates here the time is not necessary. And my raw data by default will include the time behind
Solved! Go to Solution.
Hi,
In the Query Editor, remove the time stamp into another column. Now create a relationship between the Date column of the 2 tables.
Hi,
In the Query Editor, remove the time stamp into another column. Now create a relationship between the Date column of the 2 tables.
Can you please advise how should I split it?
By delimiter > space.
Hi @Yuiitsu
Your Date Table starts in 1992, when does it end? You need the last date in the Date Table to be beyond any date in your data. The last date should be the last date in the year i.e. 31-12-xx.
Regards
Phil
Proud to be a Super User!
My last date is 2099, 12,31 .
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
99 | |
88 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |