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.
A single value for column 'wv_middledonormove' in table 'crmPhone' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.
When using a switch command:
Solved! Go to Solution.
@swarren , This can work as new column , not measure
Middle Donor Moves Phone =
SWITCH ( crmPhone[wv_middledonormove],
772490000, "Invite",
772490003, "Cultivate",
772490004, "Acknowledge",
772490005, "Service",
"None")
a new measure
Middle Donor Moves Phone =
SWITCH (
max(crmPhone[wv_middledonormove] ) ,
772490000, "Invite",
772490003, "Cultivate",
772490004, "Acknowledge",
772490005, "Service",
"None")
perfect! that totally worked. I don't know why i didn't see that before.
@swarren , This can work as new column , not measure
Middle Donor Moves Phone =
SWITCH ( crmPhone[wv_middledonormove],
772490000, "Invite",
772490003, "Cultivate",
772490004, "Acknowledge",
772490005, "Service",
"None")
a new measure
Middle Donor Moves Phone =
SWITCH (
max(crmPhone[wv_middledonormove] ) ,
772490000, "Invite",
772490003, "Cultivate",
772490004, "Acknowledge",
772490005, "Service",
"None")
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
70 | |
35 | |
21 | |
18 | |
15 |
User | Count |
---|---|
128 | |
29 | |
28 | |
24 | |
22 |