Forum Discussion

Gelain's avatar
Gelain
Frequent Visitor
9 years ago
Solved

Unique column values

Hi, The FCFO table contains the CODCFO column where customer and vendor codes are recorded. Therefore, a relationship error occurs between the TMOV and FCFO columns because one of the columns must...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    9 years ago

    Hi Gelain,

     

    How is the real data like? If it likes the sample you posted here, we could create two new table with these formulas. Finally we can create relationship. If not, could you please post a sample?

     

    Customer =
FILTER ( 'Table1', LEFT ( 'Table1'[Name], 8 ) = "Customer" )
    Supplier =
FILTER ( 'Table1', LEFT ( 'Table1'[Name], 8 ) = "Supplier" )

     

     

     

     

     

     

     

     

     

     

     

     

     

    Best Regards!

    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
9 years ago

Hi Gelain,

 

How is the real data like? If it likes the sample you posted here, we could create two new table with these formulas. Finally we can create relationship. If not, could you please post a sample?

 

Customer =
FILTER ( 'Table1', LEFT ( 'Table1'[Name], 8 ) = "Customer" )
Supplier =
FILTER ( 'Table1', LEFT ( 'Table1'[Name], 8 ) = "Supplier" )

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards!

Dale