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.
I'm using Dynamics CRM as my data source and creating a report of Won Opportunities. In CRM there is a pre-determined list of products (Products Table) and there is also the ability to use 'written-in' products (Opportunity Products Table). I need to be able to create a column/table which just contains the contents of both of these tables as, for some reason, the relationship between the two will not allow me to show them together.
Products[name]
Opportunityproducts[description]
I don't think I can't just use merge or append as the two source tables contain different columns and when I tried this it just never completes.
Any help appreciated.
Thanks
Solved! Go to Solution.
If Append in Power Query is not working, you could try a UNION DAX function like:
MyTable = UNION(DISTINCT(Sales[ItemDesc]),DISTINCT(Tickets[status]))
This would be a New Table formula.
If Append in Power Query is not working, you could try a UNION DAX function like:
MyTable = UNION(DISTINCT(Sales[ItemDesc]),DISTINCT(Tickets[status]))
This would be a New Table formula.
Perfect thank you @Greg_Deckler!
Now I need to work out how to link this to the existing tables so I can use the column in my report but that's a separate issue for me to work out.
Thanks again
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.
User | Count |
---|---|
12 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
20 | |
3 | |
2 | |
2 | |
2 |