Forum Discussion
Create relationship between two columns without unique values?
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 uniqu...
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.