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 All,
Running into an issue where there is an Item(#) that is my main dimension and relationship but it can appear in 2 locations (BPs). Is there a way to have logic that matches Item# with a BP? unsure if merge or concatanate will work because the users do not want a combinded record.
Example of issue:
Data Set that is being fed into a larger set:
the highlighed is the concate ID w/ the correct BP (column 2) as the last 2 digits. However, the relationships connect item (column 3).
Any advice or assistance is greatly appreicated.
Usually you handle these kinds of relationships in your data model. What have you tried and where are you stuck?
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 |
---|---|
106 | |
98 | |
80 | |
67 | |
63 |
User | Count |
---|---|
145 | |
111 | |
104 | |
84 | |
64 |