Price variation vs other

[GenZam1988]

Hi can you helpme to solve this scenary in PB 

I need to compare the variation of product prices, always against the first product.

And show in a table like the example below

[Anonymous · Accepted solution]

Hi @GenZam1988 ,

Please try the following methods and check if they can solve your problem:

1.Create the simple table.

2.Create the new column to calculate. Drag the column into the table visual and select don’t summarize.

Dif_price = 
VAR price_1 = SUMX(FILTER('Table', 'Table'[Product] = "Product 1"),'Table'[Price])
VAR dif_price = (DIVIDE('Table'[Price], price_1) - 1)
RETURN
    IF(dif_price = 0, BLANK(), dif_price)

3.Select percentage value and one number of decimal.

4.The result is shown below.

Best Regards,

Wisdom Wu

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

[RossEdwards]

You might find it difficult to get a good answer with such a minimal description.  The answer to your question will depend on how you have modelled your data.  How would an algorithm know what a "first" price is?  Do you flag in your dataset what is the first product?  Do you group your products in a manner so you can collate the first and others?  Is "first" something you expect to be a user choice field rather than something stored in the data?