Forum Discussion
SirBI
3 years agoFrequent Visitor
Switch Measure
I have a table "tableA" Within this table I have a column source with "Y" and "N" values.
I need to create a Measure (not calcuated column) to create a mapping.
Y = Yes
N = No.
I'm trying the switch statement but my column does not show.
switch(tableaA.source,"Y","Yes", "No"). What am I doing wrong?
SirBI , In case of measure you can use aggregated columns
example
switch(Max(tableaA[source]),
"Y","Yes",
"No")
1 Reply
- amitchandakSuper User
SirBI , In case of measure you can use aggregated columns
example
switch(Max(tableaA[source]),
"Y","Yes",
"No")