Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I'm working on a graph of bookings by sales person -- I have a table of 2015 data and a table of 2016 data.
Table 1 - 2015
Sales Person Amount
John $4,000
Steve $5,000
John $2,300
Alex $1,500
Table 2 - 2016
Sales Person Amount
John $4,000
Katie $3,900
Steve $5,000
Larry $2,000
Steve $2,300
I need to create a list of the unique sales people in a new table.
Table 3 - New with all sales people from 2015 & 2016
John
Katie
Steve
Larry
Alex
Thanks.
Solved! Go to Solution.
@NorthernGuy This question should be posted in desktop forum. In power bi desktop go to query editor, under Home tab click Enter Data, Name as 'Merged' and click OK.
Then select new created table and under Home tab, under Combine, click Append Queries, Three or more tables, add previous two tables and click OK. This should give you table as below.
Then for Merged table remove Column1, Amount, highlight SalesPerson column and click Remove Duplicates.
@NorthernGuy This question should be posted in desktop forum. In power bi desktop go to query editor, under Home tab click Enter Data, Name as 'Merged' and click OK.
Then select new created table and under Home tab, under Combine, click Append Queries, Three or more tables, add previous two tables and click OK. This should give you table as below.
Then for Merged table remove Column1, Amount, highlight SalesPerson column and click Remove Duplicates.
Thanks -- worked great.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.