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 am trying to create a relationship along 'Service Location' between two data sets (SLA Table and FSA Table) however I'm having trouble because the names are not unique in either table.
SLA Table contains Service Location Ascend (unique) which translates into Service Location (not unique - eg two Service Location Ascend can roll up to one Service Location for reporting purposes).
FSA Table is my market share geographic info. Each FSA (unique) is rolled up to a Service Location (not unique).
I'm very new to Power BI. Would anyone have any suggestion on how I can create a unique field or find a work around that would allow me to link these data sets along Service Location.
Solved! Go to Solution.
@SharonHMA You can go to power bi desktop query editor -> create custom columns that can be join of two columns to make it unique or you can create calculated columns under Modelling tab that can be join of two other columns to make it unique.
Hi @SharonHMA,
You can use dax formula to create a new table(distinct) based on “Service Location” and “Service Location Ascend”, then use the new table to link above tables’ columns.
For example:
Table = DISTINCT(UNION(VALUES(Sheet1[Code]),VALUES(Sheet2[Code])))
Regards,
Xiaoxin Sheng
@SharonHMA You can go to power bi desktop query editor -> create custom columns that can be join of two columns to make it unique or you can create calculated columns under Modelling tab that can be join of two other columns to make it unique.
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 |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |