How to calculate Price Index

[Sunilrane]

Hi can anybody help how to calculate Price Index of our brand and for the competition brands?

[Anonymous]

Hi @Sunilrane ,

If you want to create a rank for the price, you can try rankx function as  amitchandak mentioned before. If this does not match your requirement, please share a sample with us and you can show us a screenshot with the result you want. This will make us easier to find the solution. 

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Sunilrane , Not very clear, can you explain

new column

rank = rankx(filter(Table,[brand] = earlier([brand]) , [price],,asc,dense)

or

rank = rankx(filter(Table,[brand] = earlier([brand]) , [price],,desc,dense)