Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Capture price changes

Hi, I have below data, I would like to capture the changes of the price for each Part No:     I would like the result to be like below, capture the price whenever it changes: can som...
Need Help
Fowmy's avatar
Fowmy
Super User
5 years ago

Anonymous 

Can you try this  as a new column to your table and check

Column = 

VAR _PRICE = MAXX(FILTER('Table', 'Table'[Part No] = EARLIER('Table'[Part No]) && 'Table'[Date] < EARLIER('Table'[Date])), 'Table'[Pirce])
VAR _PART= MAXX(FILTER('Table', 'Table'[Part No] = EARLIER('Table'[Part No]) && 'Table'[Date] < EARLIER('Table'[Date])), 'Table'[Part No])
VAR CP = [Pirce]

RETURN

IF(           
    [Part No] = _PART ||( _PART=BLANK() && _PART <> BLANK()),
    [Pirce] , 
    BLANK() 
)

 

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks @Fowmy , my data source is a tabular model, and the source table is very large, around 4 millions record, so I was trying to avoid adding calcualted column.

Is there away to just do it in a measure or measures?

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    One thing I forgot to menation that date column is from another table, but it is join with the part table.