Forum Discussion
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...
Hi Anonymous
you can do this by a easy function:
v-diye-msft is Ealiest Date a calculated column? can you please share the DAX.
Hi Anonymous
I didn't write DAX, just change the aggreate type of date column, you'll make it.
v-diye-msft thanks , I will try it.
v-diye-msft , below 2 tables are the row data in table 1 and aggregated in table 2 for a particulare part number, it gives the correct unique price, but the earliest dates in table 2 are wrong, it looks like it is getting the earliest date regardless of the part number.
Also can you please advise how can I add the sum of the distinct prices, for below example the total sum is 31.23