Forum Discussion

SirBI's avatar
SirBI
Frequent Visitor
3 years ago
Solved

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

  • SirBI , In case of measure you can use aggregated columns

     

    example

    switch(Max(tableaA[source]),

    "Y","Yes",

    "No")