Forum Discussion
nardtmo
Helper III
Helper IIIRanking issue
Hi everyone, i have this table with desired ranking output column rank based on points_SA (desc) and rerank every date change. dax formula below is working but not giving me the desired o...
nardtmoHelper III
Helper IIIthanks Greg. Another pespective have two rankings, determine rank SA pt change in values and set the switch condition.. other words cant figure it out. Appreciate the help
| Market Id | Rank_MR7_SA | Rank_SA_pt | if Rank_SA_pt row2=row1 | condition |
| Atlanta | 1 | 1 | FALSE | false keep using col D1 values |
| Miami | 2 | 2 | FALSE | false keep using col D2 values |
| Philadelphia | 3 | 2 | TRUE | true and stay true use D2 until false |
| North Carolina | 4 | 2 | TRUE | true and stay true use D2 until false |
| New Jersey | 5 | 3 | FALSE | false keep using col D6 values |
| New England | 6 | 3 | TRUE | true and stay true use D6 until false |
| New York | 7 | 3 | TRUE | true and stay true use D6 until false |
| Washington DC | 8 | 4 | FALSE | false keep using col D9 values |
| Los Angeles | 9 | 4 | TRUE | true and stay true use D9 until false |
| San Francisco | 10 | 5 | FALSE | false keep using col D10 values |
| Southern California | 11 | 6 | FALSE | false keep using col D11 values |