Forum Discussion

sujana_m's avatar
sujana_m
Frequent Visitor
2 years ago

Calculating Price Difference between SKUs

Hi,   I need help calculating the price difference between pack sizes of the same SKU. Below is the sample output I received:     The values in Price difference are partially correct. Ther...
Need Help
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
2 years ago

Hi, 

I am not sure how the semantic model looks like, but please try something like below if it suits your requirement.

 

CIA PriceDifference =
VAR CRSellUnit =
    MIN ( 'PRODUCT'[SELL_UNIT] )
VAR CRPrice_IV = [CIA Price Per Unit]
VAR PRSellUnit =
    MAXX (
        FILTER ( ALL ( 'PRODUCT'[SELL_UNIT] ), 'PRODUCT'[SELL_UNIT] < CRSellUnit ),
        'PRODUCT'[SELL_UNIT]
    )
VAR PRPrice_FV =
    CALCULATE ( [CIA Price Per Unit], 'PRODUCT'[SELL_UNIT] = PRSellUnit )
RETURN
    IF ( ISBLANK ( PRPrice_FV ), BLANK (), PRPrice_FV - CRPrice_IV )
sujana_m's avatar
sujana_m
Frequent Visitor
2 years ago


This is the output I am getting.

Here is a snapshot of the model: