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 tr...
  • amitchandak's avatar
    3 years ago

    SirBI , In case of measure you can use aggregated columns

     

    example

    switch(Max(tableaA[source]),

    "Y","Yes",

    "No")