Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Formula Help

I have used a RANKX formula on a column named Clothes and now I want the top third of the data to get assigned a value of 15, the middle third of the data to be assigned 10, and the bottom third to b...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    Perhaps:

     

     

    Column = 
  VAR __break = MAX([Rank])/3
RETURN
  SWITCH(TRUE(),
    [Rank] <= __break,15,
    [Rank] > 2*__break,5,
    10
  )

     

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

Perhaps:

 

 

Column = 
  VAR __break = MAX([Rank])/3
RETURN
  SWITCH(TRUE(),
    [Rank] <= __break,15,
    [Rank] > 2*__break,5,
    10
  )

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    HI Greg_Deckler 

     

    I am trying to write this formula in my Power Bi Desktop and I am not sure how to do so.  I have never written a formula that looks like this before. 

    • Greg_Deckler's avatar
      Greg_Deckler
      Community Champion
      6 years ago

      Anonymous  - Right-click the table in the Fields area, New Column. Formula bar should appear, copy and paste the code.