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

Anonymous
Not applicable
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Selectcolumns
06-06-2023
05:40 AM
I am using select columns and storing 2 columns in that selectcolumns table
then i am storing that into a variable.
how can i access onlyone column out of it.?
Solved! Go to Solution.
1 ACCEPTED SOLUTION
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 REPLIES 3

Anonymous
Not applicable
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-12-2023
08:00 AM
is there a way we can restrict the blank values during fectching data using selectcolumns.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-06-2023
05:49 AM
@Anonymous Couple different ways. You could use another SELECTCOLUMNS. Also, you can use an X aggregator, MAXX, MINX, SUMX, etc.
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans
DAX is easy, CALCULATE makes DAX hard...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Helpful resources
Announcements
Power BI Monthly Update - July 2025
Check out the July 2025 Power BI update to learn about new features.

Recommendations
Subject | Author | Posted | |
---|---|---|---|
06-05-2025 06:29 AM | |||
05-23-2025 08:02 AM | |||
Anonymous
| 02-14-2021 11:48 AM | ||
03-09-2016 07:34 PM | |||
05-03-2018 12:52 AM |
Top Solution Authors (Last Month)
User | Count |
---|---|
24 | |
9 | |
7 | |
6 | |
6 |
Top Kudoed Authors (Last Month)
User | Count |
---|---|
29 | |
11 | |
11 | |
10 | |
6 |