The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.
is there a way we can restrict the blank values during fectching data using selectcolumns.
@Anonymous Couple different ways. You could use another SELECTCOLUMNS. Also, you can use an X aggregator, MAXX, MINX, SUMX, etc.
User | Count |
---|---|
28 | |
12 | |
8 | |
7 | |
5 |
User | Count |
---|---|
36 | |
14 | |
12 | |
7 | |
7 |