Reply
Andy1984
Frequent Visitor
Partially syndicated - Outbound

Power BI add new table with existing data

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_0-1678460300807.png

 

1 ACCEPTED SOLUTION
Andy1984
Frequent Visitor

Syndicated - Outbound

I find the solution by my self. 

Andy1984_0-1678464966422.png

 

View solution in original post

4 REPLIES 4
Andy1984
Frequent Visitor

Syndicated - Outbound

I find the solution by my self. 

Andy1984_0-1678464966422.png

 

olgad
Super User
Super User

Syndicated - Outbound

Hi,

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

 

It will provide you with the column containing distinct values


DID I ANSWER YOUR QUESTION? PLEASE MARK MY POST AS A SOLUTION! APPRECIATE YOUR KUDO/LIKE!
PROUD TO BE A SUPER USER!
Best Stories, Interesting Cases: PowerBI Storytime Newsletter
Linkedin Profile: Linkedin
YouTube Channel: PowerBI Storytime

Syndicated - Outbound

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

Andy1984_0-1678462603563.png

 

 

Syndicated - Outbound

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


DID I ANSWER YOUR QUESTION? PLEASE MARK MY POST AS A SOLUTION! APPRECIATE YOUR KUDO/LIKE!
PROUD TO BE A SUPER USER!
Best Stories, Interesting Cases: PowerBI Storytime Newsletter
Linkedin Profile: Linkedin
YouTube Channel: PowerBI Storytime
avatar user

Helpful resources

Announcements
FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)