Forum Discussion
Powerbi Desktop table relationships
Hi Mellan3
Why don't you create a Dimension table? Maybe there is already one available on the database? If not in Power Query you could make duplicates of both tables remove all columns except the JobNumber in both tables append them together and remove duplicates
Load the data into your report. Create a one to many relationship from the DIM table to both tables on the JobNumber. If you have a DIM date table , you can create a Relationship similar to the othe rtable and you can then filter by date and create time intelligence measures also
Thanks
Joe
If this post helps, then please Accept it as the solution
Solution SageHi Mellan3
Why don't you create a Dimension table? Maybe there is already one available on the database? If not in Power Query you could make duplicates of both tables remove all columns except the JobNumber in both tables append them together and remove duplicates
Load the data into your report. Create a one to many relationship from the DIM table to both tables on the JobNumber. If you have a DIM date table , you can create a Relationship similar to the othe rtable and you can then filter by date and create time intelligence measures also
Thanks
Joe
If this post helps, then please Accept it as the solution