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

Wout's avatar
Wout
Icon for Helper I rankHelper I
9 years ago

Mm recognizable. Can you customize the data source? The easiest way is to add an unique ID/primary key.