RankX Ranking Ties
Hello, Can someone help with how to break ties? I have the below dax forumla creating a ranking column in my table using item code that thens ranks by the earliest date. I tried adding dense to the ties portion of the formula and I get this error Ranking = VAR __cd = PO_PurchaseOrderDetail[ItemCode] RETURN RANKX( FILTER( PO_PurchaseOrderDetail, PO_PurchaseOrderDetail[ItemCode] = __cd ),PO_PurchaseOrderDetail[PODATE]) Ranking error using Dense: Rtotal = VAR __po = PO_PurchaseOrderDetail[PurchaseOrderNo] VAR __cd = PO_PurchaseOrderDetail[ItemCode] RETURN RANKX( FILTER( PO_PurchaseOrderDetail, PO_PurchaseOrderDetail[ItemCode] = __cd ),PO_PurchaseOrderDetail[PODATE], DENSE) Results: Expected Ressult: Thanks so much in advance!
