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.
I'm trying to relate two date&time columns in two separate tables.
One column captures the date&time a prospect entered my recruitment system.
The other column captures the date&time of unique page views from our websites google analytics.
Because of the volume of data in each of these tables, there are a few duplicate values in each column. This is not a flaw in the data. Is it impossible to create relationships between columns that do not have 100% unique values? What are my options, how should I proceed with this?
Solved! Go to Solution.
@Anonymous, it is always good practice to have a separate date table, something like the following will help you create one: https://www.agilebi.com.au/blog/power-bi-date-dimension
I would then join each of your 2 tables to the separate date table to get around your issue.
@Anonymous, it is always good practice to have a separate date table, something like the following will help you create one: https://www.agilebi.com.au/blog/power-bi-date-dimension
I would then join each of your 2 tables to the separate date table to get around your issue.
@jcarville Awesome idea! That worked exactly as I needed it to. Really appreciate it.
In the past what i've done to overcome this challenge is simply hop in the query editor and "remove duplicates" from the data set. I wouldnt advise you do this is many duplicates exist but if its a matter of very minimal data points causing the issue it can at least get you started.
Many to many relationships cannot exist in PBI as far as I know.
@Anonymous Considering the scope of my inquiry I can probably get away with this, at least as a stopgap solution! Thanks.
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |