How can I retrieve distinct values from multiple columns using Power BI

0 votes
How can I retrieve distinct values from multiple columns using Power BI?

To retrieve distinct values from multiple columns in Power BI, use the "UNION" and "SELECTCOLUMNS" DAX functions to combine columns into a single virtual table and then apply the "DISTINCT" function for unique values.
Oct 23 in Power BI by Evanjalin
 • 8,370 points • 72 views

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.

Related Questions In Power BI

+1 vote
0 answers

How can I count the distinct values in a column using Power BI?

How can I count the distinct values ...READ MORE

Oct 23 in Power BI by Evanjalin
 • 8,370 points • 210 views
+1 vote
1 answer

How can I share and protect an Excel document online (using Powerpivot), without Sharepoint & Power BI?

Take a look again at Power BI. ...READ MORE

answered Oct 23, 2018 in Power BI by Annie97
 • 2,160 points • 1,272 views
0 votes
0 answers

How can I create dynamic parameters in Power BI using DAX?

How can I create dynamic parameters in ...READ MORE

Oct 14 in Power BI by anonymous
 • 8,370 points • 97 views
+2 votes
1 answer

How can I create dynamic parameters in Power BI using DAX?

Similarly, in Power BI, utilizing DAX, one ...READ MORE

answered Oct 22 in Power BI by pooja
 • 8,470 points • 266 views
0 votes
1 answer

How can I troubleshoot a scenario where Power BI loads data with wrong formats or encoding from a CSV file?

Power BI loading a CSV file containing ...READ MORE

answered Nov 11 in Power BI by pooja
 • 8,470 points • 78 views
0 votes
1 answer

How can I combine data from REST APIs with Power BI for real-time reporting?

The ability to combine real-time reporting via ...READ MORE

answered Nov 15 in Power BI by pooja
 • 8,470 points • 62 views
0 votes
1 answer

Displaying Table Schema using Power BI with Azure IoT Hub

Answering your first question, Event Hubs are ...READ MORE

answered Aug 1, 2018 in IoT (Internet of Things) by nirvana
 • 3,130 points • 1,360 views
+1 vote
1 answer

Unable to install connector for Power Bi and PostgreSQL

I think the problem is not at ...READ MORE

answered Aug 22, 2018 in Power BI by nirvana
 • 3,130 points • 2,755 views
+2 votes
2 answers

Migrate power bi collection to power bi embedded

I agree with Kalgi, this method is ...READ MORE

answered Oct 11, 2018 in Power BI by Hannah
 • 18,520 points • 1,527 views
+1 vote
1 answer

Connect power bi desktop to dataset and create custom reports

Yes using Power BI REST API to ...READ MORE

answered Sep 18, 2018 in Power BI by Kalgi
 • 52,350 points • 1,675 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.