Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Power BI add new table with existing data
03-10-2023
06:59 AM
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:
Solved! Go to Solution.
1 ACCEPTED SOLUTION
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
4 REPLIES 4
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-10-2023
08:16 AM

I find the solution by my self.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-10-2023
07:07 AM

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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-10-2023
08:22 AM

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

Helpful resources
Recommendations
Subject | Author | Posted | |
---|---|---|---|
05-28-2024 12:45 PM | |||
07-17-2024 11:03 PM | |||
01-15-2024 04:08 AM | |||
01-20-2024 06:58 PM | |||
06-06-2024 07:06 AM |
Featured Topics
Top Kudoed Authors (Last Month)
User | Count |
---|---|
128 | |
121 | |
85 | |
59 | |
47 |