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,
In the image below, the first 2 columns are the input columns and the third one is the expected result. In each row of the table, for the fruit in the current row, i wish to concatenate all the unique calorie values via a calculated column formula.
Fruit | Calorie | Expected result |
Apple | High | High, Low |
Pear | Medium | Medium, High |
Banana | High | High, Medium |
Apple | Low | High, Low |
Banana | Medium | High, Medium |
Pear | High | Medium, High |
Apple | High | High, Low |
Thank you for your help.
Solved! Go to Solution.
Try this calculated column:
Unique Calorie =
VAR vFruit = Table1[Fruit]
VAR vTable =
CALCULATETABLE (
VALUES ( Table1[Calorie] ),
Table1[Fruit] = vFruit,
ALL ( Table1 )
)
VAR vResult =
CONCATENATEX ( vTable, Table1[Calorie], ", " )
RETURN
vResult
Proud to be a Super User!
Try this calculated column:
Unique Calorie =
VAR vFruit = Table1[Fruit]
VAR vTable =
CALCULATETABLE (
VALUES ( Table1[Calorie] ),
Table1[Fruit] = vFruit,
ALL ( Table1 )
)
VAR vResult =
CONCATENATEX ( vTable, Table1[Calorie], ", " )
RETURN
vResult
Proud to be a Super User!
Hi,
Thank you for your help. Your formula worked very well.
User | Count |
---|---|
83 | |
76 | |
71 | |
68 | |
54 |
User | Count |
---|---|
105 | |
100 | |
91 | |
79 | |
68 |