Creating a STEP Chart using powerpivot

[AmitM]

Hi,


I want to display prices using a step chart (Y=Price, X=Date).


The reason I need Step Chart and not a regular line chart is because the prices remain the same till new update arrives.


Anyone did it?


I saw explanations how doing it on the web, but all of them used a predefined range to manipulate the data. I need something dynamic to fit the changes in the data (such as when using slicers to filter the results)


THX

 

[scottsen]

I'm generally more comfortable in DAX than any excel/charting weirdness, so I would like write a measure that is 'what was the average price on the most recent date we had a price'

 

[AmitM]

Appreciate if you can send an example how you would have resolved it.

THX

 

[scottsen]

See if this article helps? Alberto Ferrari : Thinking in DAX: Counting Products in the Current Status with PowerPivot