Level 1Microsoft Certified: Power BI Data Analyst Associate
10%
Q1
Suppose you've created a query in Power BI Desktop called "consumers", which combines the rows from three external tables containing consumer data into a single table called "consumer". Your objective is to assign a unique ID value to each row in the "consumer" table. What would be the most effective approach to add a new fabricated ID column to the "consumer" table?
Select Answer