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
v-diye-msft's avatar
v-diye-msft
Community Support
5 years ago

Hi Anonymous 

 

you can do this by a easy function:

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    v-diye-msft is Ealiest Date a calculated column? can you please share the DAX.

     

    • v-diye-msft's avatar
      v-diye-msft
      Community Support
      5 years ago

      Hi Anonymous 

       

      I didn't write DAX, just change the aggreate type of date column, you'll make it.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        v-diye-msft thanks , I will try it.