Forum Discussion

ScottWill's avatar
ScottWill
Regular Visitor
4 years ago
Solved

Create a Measure based on text in table

Hello  I need help creating a measure based on data in a table. Please see example blow  I have a table Named ModelMaster  In the table I have fields MODELCODE      VEHTYPE   Table Name: ModelMa...
Need Help
  • ScottWill's avatar
    ScottWill
    4 years ago

    I believe I figured it out 

    VEH RC ELIGABLE = SWITCH (
    SELECTEDVALUE ( ModelMaster[VEHICLETYPE]),
    "C", "Tri",
    "T", "Bi",
    "", "UNK"
    )
v-luwang-msft's avatar
v-luwang-msft
Community Support
4 years ago

Hi ScottWill ，

You can mark your own answers as correct so that more people can be helped.

 

Best Regards

Lucien