Forum Discussion
Unrelated Tables Question
I have the following 2 tables that are currently unrelated. Table 1 Run Start Run End Run ID Table 2 Eventtime Reject Count What I'd like to do is compare the Eventtime in Tab...
Whatever approach you take, if table 1 has multiple rows with overlapping Run Start/Run End times you would be in danger of potentially creating unwanted duplicate rows by linking up to table 2 using only a date/time field.
If this is not an issue, you may want to consider linking the tables outside of Power BI in a view (depending on the data source) and then pulling the view into the report.
Could I summarize the two tables and do a date/time comparison within the summarize? The two tables do not have overlapping start/stop times.
