Power BI add new table with existing data

[Andy1984]

Hi,

I need your help. I have created a new table with existing data. The colum "new" show me now all of the data. I want that it search for the differnt text and give only one back if he find more and not all of them:

[Andy1984 · Accepted solution]

I find the solution by my self. 

[olgad]

Hi,

use another formula for your table Values(Konto[Buchungstext])

It will provide you with the column containing distinct values

[Andy1984]

@olgad  I have tried this before but this is not possible

[olgad]

Happy you managed to find a solution!  But Table=Values(Konto[Buchungstext])would have worked anyways😉😉 What didnt work for you was not this formula