Forum Discussion

Anonymous

Not applicable

7 years ago

Create new table from Master Data without duplicates

Hi Everyone. I am new to PowerBI and appreciate your help. I am in the transport industry and I have a master data sheet which shows every single load that was done and every drop on each load. ...

Anonymous

Not applicable

7 years ago

Hi Qhawe,

You can have another table with the different name and it has the distinct values of load numbers with the related info.

You can do transformations in Power BI to remove the columns that are not required.

Regards,

Pradeep

Anonymous
Not applicable
7 years ago
Hi Pauwnrajpp.

Thank you for your response.
Once I have to distinct values on load reference in the new table, how do I get start time and finish time to give me disctinct value linked to the load reference number?

My issue has been that the lookupvalue function give an error that "multiple values were found".

Regards
Qhawe
- Anonymous
  Not applicable
  7 years ago
  You can get those start time and finish time for the distinct values from table 1.
  
  Because, in your Data Model, Table 1 and Table 2 has duplicate entries to connect with the relation.
  
  To avoid this, get the distinct value from the table 2 key column and have it inbetween table 1 and table 2.
  
  This new table is called factless fact table and it should contain only distinct key value.
  
  1. Table 1 to factlessfact table will have many to one relationship
  2. Factlessfact table to Table 2 will have one to many relationship and it should be bidirectional.
  
  Regards,
  Pradeep

Related content