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, in Query Editor, select the 2 columns and go to Remove Rows - Remove Duplicates.
Regards
Victor
Lima - Peru
With DAX, you can use the "ALL" function to get unique combination of Rows.
From the Modelling Tab, select NEW TABLE and use this formula
NewTable= ALL(TableName[Customer] , TableName[Product])
@MarianneElver not sure if I undertand clearly what you want. How the null get to the second table? Are you looking just for a unique entry for each combination customer/Product ? if is that the case follow @Vvelarde suggestion. If not ,please provide more details.
With DAX, you can use the "ALL" function to get unique combination of Rows.
From the Modelling Tab, select NEW TABLE and use this formula
NewTable= ALL(TableName[Customer] , TableName[Product])
Hi, in Query Editor, select the 2 columns and go to Remove Rows - Remove Duplicates.
Regards
Victor
Lima - Peru
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 |
---|---|
110 | |
97 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |