Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

I need help creating a Dax expression

I need help creating a Dax expression where If a field name (Status) is saying reported, then it equals not started

Show and Tell

1 Reply

  • Chakravarthy's avatar
    Chakravarthy
    Resolver II
    2 years ago

    Hi Anonymous  - Please try to create Calcualted Column using below code

    Using IF:  If(Table[Status]="reported","not started","Started")

    Using Switch:

    SWITCH(Table[Status],

    "reported","not started",

    "Started"

    )