Price Change Indicator

Question

Dears,&nbsp;I have below table and would like to create a new column on in same prices column to show indicator for prices change increase/decrease comparing previous date prices.&nbsp;ITEMIDPURCHUNITLatest INVENTDATECurrencyPRICEUNITPKG-021Pcs11/22/2018 0:00SAR&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.50PKG-021Pcs11/01/2018 0:00SAR&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.50PKG-021Pcs08/27/2018 0:00SAR&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.50PKG-021Pcs11/26/2017 0:00SAR&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.50PKG-021Pcs06/01/2017 0:00SAR&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.52PKG-021Pcs03/22/2017 0:00SAR&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.51PKG-021Pcs12/21/2016 0:00SAR&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.55PKG-021Pcs12/14/2016 0:00SAR&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.55PKG-021Pcs09/25/2016 0:00SAR&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.70PKG-021Pcs02/10/2016 0:00SAR&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.57

v-cherch-msft · Accepted Answer

Hi&nbsp;Anonymous&nbsp;You may create a index column first. Then you may get the indicator with calculated column as below:&nbsp;Index =
RANKX (
    Table1,
    CALCULATE (
        MIN ( Table1[Latest INVENTDATE] ),
        ALLEXCEPT ( Table1, Table1[PRICEUNIT] )
    ),
    ,
    ASC,
    DENSE
)indicator =
VAR pre =
    CALCULATE (
        MAX ( Table1[PRICEUNIT] ),
        FILTER ( Table1, Table1[Index] = EARLIER ( Table1[Index] ) - 1 )
    )
RETURN
    IF ( ISBLANK ( pre ), BLANK (), Table1[PRICEUNIT] - pre )&nbsp;Regards,Cherie

Forum Discussion

Price Change Indicator

2 Replies

Related content

Estimation of impac Pricing / Capacity Usage change

PBIRS Deployment Pricing

Reserved Fabric Pricing

Track price changes

Displaying Change Indicators

ITEMID	PURCHUNIT	Latest INVENTDATE	Currency	PRICEUNIT
PKG-021	Pcs	11/22/2018 0:00	SAR	0.50
PKG-021	Pcs	11/01/2018 0:00	SAR	0.50
PKG-021	Pcs	08/27/2018 0:00	SAR	0.50
PKG-021	Pcs	11/26/2017 0:00	SAR	0.50
PKG-021	Pcs	06/01/2017 0:00	SAR	0.52
PKG-021	Pcs	03/22/2017 0:00	SAR	0.51
PKG-021	Pcs	12/21/2016 0:00	SAR	0.55
PKG-021	Pcs	12/14/2016 0:00	SAR	0.55
PKG-021	Pcs	09/25/2016 0:00	SAR	0.70
PKG-021	Pcs	02/10/2016 0:00	SAR	0.57