Forum Discussion
Help fixing relationships between two tables.
So I have Input table that looks like the following: I have another table called Labor Detail that has the same exact columns except Predicted with different names. For example, Department...
In either data source, Power Query, or DAX calculated column, create a new column that's unique to those 4 columns. Power BI doens't support multiple key relationships, so you'd have to create a key column that defines the grain of your table.
If in Power Query, "Add index" will do.