Forum Discussion

Hidde's avatar
Hidde
Icon for Helper I rankHelper I
8 years ago
Solved

Count price position in PowerBI

Hi, I am struggling with finding a solution for this:   I have a lot of prices per product, so the data looks like this:   Product - client - price - Price Position Product 1 - Client 1 - €2 - 1...
Need Help
  • v-xjiin-msft's avatar
    v-xjiin-msft
    8 years ago

    Hi Hidde,

     

    To achieve your requirement, you can try this calculated column:

     

    Price Ranking =
RANKX (
    FILTER ( 'Rank', 'Rank'[Product] = EARLIER ( 'Rank'[Product] ) ),
    'Rank'[Price],
    ,
    ASC
)

     

    Thanks,
    Xi Jin.

v-xjiin-msft's avatar
v-xjiin-msft
Icon for Solution Sage rankSolution Sage
8 years ago

Hi Hidde,

 

To achieve your requirement, you can try this calculated column:

 

Price Ranking =
RANKX (
    FILTER ( 'Rank', 'Rank'[Product] = EARLIER ( 'Rank'[Product] ) ),
    'Rank'[Price],
    ,
    ASC
)

 

Thanks,
Xi Jin.

Hidde's avatar
Hidde
Icon for Helper I rankHelper I
8 years ago

This works perfectly, thanks! What does the EARLIER function do in this context?