Forum Discussion

dw700d's avatar
dw700d
Post Patron
6 years ago
Solved

Using a switch or if statement for different conditions

I would like to create a measure that categorizes the "running total spend" column by  "Contribution type"

 

 

Running Total amounts less than 750k should be considered - Contribution 1

Running Total amounts greater than 750k  should be considered– Contribution 2

Running Total amounts greater than 1.5M should be considered – Contribution 3

 

I think I can a accomplish with the switch function. anyone have thought on how i can accomplish this

Need Help
  • Fowmy's avatar
    Fowmy
    6 years ago

    dw700d 

    Try this, you can also use SWITCH,

    Contribution = 

VAR RT = [Running Total] RETURN

IF(
    RT < 750000,  "CONT1",
    IF( RT > 1500000,  "CONT3",
    "CONT2"
)
)

     

    ________________________

    Did I answer your question? Mark this post as a solution, this will help others!.

    Click on the Thumbs-Up icon on the right if you like this reply 🙂

    YouTube, LinkedIn

1 Reply

  • Fowmy's avatar
    Fowmy
    Super User
    6 years ago

    dw700d 

    Try this, you can also use SWITCH,

    Contribution = 

VAR RT = [Running Total] RETURN

IF(
    RT < 750000,  "CONT1",
    IF( RT > 1500000,  "CONT3",
    "CONT2"
)
)

     

    ________________________

    Did I answer your question? Mark this post as a solution, this will help others!.

    Click on the Thumbs-Up icon on the right if you like this reply 🙂

    YouTube, LinkedIn