Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I have requirement in which I need to create a new column based on the different combination of values from some other columns.
For example Column Product contains - A,B,C fields and Column category contains - D,E,F. The new column is created as :
Combination || New column values
A & D - 1
B & E - 2
C & F - 3
Thanks in advance
Hi Amit, Thanks for the response
These two columns are present in different tables.
@Anonymous , what is logic
You have append
[Product] & [Category]
You can have rank
rankx(Table, [Combined column],,asc,dense)
User | Count |
---|---|
81 | |
79 | |
71 | |
70 | |
54 |
User | Count |
---|---|
107 | |
99 | |
88 | |
79 | |
67 |