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!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Helpful resources
Announcements
Join our Fabric User Panel
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Power BI Monthly Update - June 2025
Check out the June 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 | |||
03-09-2016 07:34 PM | |||
Anonymous
| 02-14-2021 11:48 AM | ||
05-03-2018 12:52 AM |
Top Solution Authors (Last Month)
User | Count |
---|---|
10 | |
9 | |
8 | |
7 | |
6 |
Top Kudoed Authors (Last Month)
User | Count |
---|---|
14 | |
13 | |
11 | |
9 | |
9 |