Forum Discussion
Measure with two different columns
Yes, that's kind of sample data. However, you can simplify that and not the screenshot. It's very hard for us to create the solution based on the screenshot. You can just paste some data in the reply. At last, pls let us know what the result you want to get based on the data you provided.
i just created some simple data and provide a solution. pls see the attachment and check if this is what you want.
The relationship is many to many. You need to clean up the data and make it to be one to many or many to one.
Hi again Ryan
It might be a stupid question, but how would I go about cleaning up date data?
I think you need to check
1. if there is any blank value for FQN
2. what's the reason caused many to many relationship? Is it correct that you can have values that does not exists in the other table?
at last i think you need a DIM table
Table 2 = DISTINCT(UNION(DISTINCT('Table'[FQN]),DISTINCT('Table (2)'[FQN])))use this table and create one to many relationships with the current two tables.Hi Ryan
There are no blank values for FQN.
I believe the reason is that I have tried to make a relationship between the two tables, and the DateTime are often not the same, i.e.:
- 24 August 2021 10:04 for one table and
- 24 August 2021 10:01 for the other one
Can I ask (so I understand the process) why you want to create a relationship between the names (FQN)? Is that how you would normally do something like this?