Track price changes

Thats a pit, I hoped that it would be a bit easier.

You might have to take this approach then:

https://social.technet.microsoft.com/Forums/en-US/3c0ed4e6-bb54-4efb-9fd3-8b950dfccea0/create-a-step-chart-using-powerpivot?forum=sqlkjpowerpivotforexcel

DimDate needs to be disconnected. So if you have a DimDate already that needs to stay connected for other purposes, you need to create a new one specifically for this measure that will stay disconnected. Make sure to take your Date-field from therer to your report.

I can help write the SQL if you want, but we have enough brain power here... we should be able to pull this off :)

I feel like both your table and line chart ... are relying on the Dates table (based on your use of LASTDATE(Dates[Date]) but neither of these are using your Dates table?

If you put Dates "on rows" does that work w/ your measure!?

Nickodemus

hi, the graphic wanted should be look like this?.

If the answer is yes, please follow this few steps

1. Create a calendar table with the dates (Disconnected)

2. Create a measure

LastPrice =
IF (
    HASONEVALUE ( MyCalendar[Date] ),
    CALCULATE (
        LASTNONBLANK ( Table1[Price], Table1[Price] ),
        FILTER ( Table1, Table1[Date] <= VALUES ( MyCalendar[Date] ) )
    )
)

3. Insert a Visual with

Date from Calendar Table

Size in Legend

LastPrice in Values

Also a Slicer to select the product.