Dax Formula Help

[LeanneShapro]

I am new to DAX and need some help creating a formula that says, If a particular column has a value greater than 15k, label it "A", If that column is greater than 60k, label it "B". 

Can someone recommend a formula example that will help me get started? 

Thanks in advance!

[Greg_Deckler · Accepted solution]

Another way to do this would be something like:

Column = 
SWITCH(
  TRUE(),
  [Column1]>15000,"A",
  [Column1]>60000,"B",
  "C"
)

[Anonymous]

Hey @LeanneShapro

It would be something like:

Column =
IF(
   Table[Column] > 60000,
   "B",
   IF(
      Table[Column] > 15000,
      "A",
      BLANK()
   )
)

The BLANK() is serving as the else condition and you can change this to make it whatever value you want.

Hope this helps,

Parker