topic Re: How to calculate Price Index in DAX Commands and Tips

How to calculate Price Index

Sunilrane — Tue, 22 Feb 2022 14:55:24 GMT

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

Re: How to calculate Price Index

amitchandak — Tue, 22 Feb 2022 16:01:38 GMT

Sunilrane , Not very clear, can you explain

new column

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

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

Re: How to calculate Price Index

Anonymous — Fri, 25 Feb 2022 09:22:19 GMT

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.