Displaying data for previous dates from same week on line chart

[savne]

Hi,

I collect data once a week. I have created a table with dates and a column in the appropriate format for weeks, along with a slicer that allows me to select the desired date range.

My measure on the chart is:

Measure = SUMX ( FILTER ( 'datetable'[date] <= TODAY() ), CALCULATE ( SUM ('MyTable'[Values] ) + 0 ))

How can I make it so that when selecting a date where no data has been recorded, the beginning of the chart displays data from the previous date when the data was recorded, instead of showing 0?

For example, if my date falls within the week 2018w21, and the selected day on the slicer belongs to that week but no data was recorded on that day, it should display the value from the day when the data for that week was recorded instead of 0.

[amitchandak]

@savne , You measure

measure = SUMX ( FILTER ( 'datetable'[date] <= TODAY() ), CALCULATE ( SUM ('MyTable'[Values] ) + 0 ))

New meausre
new Measure =
var _min = Minx(filter(allselected(datetable), datetable[Date]))
return
if( _min = max(datetable[Date]) && isblank( [measure]) , CALCULATE ( SUM ('MyTable'[Values] ), previousday('datetable'[date]) ),
[Measure])

[savne]

Thank you for the answer, but first, there are not enough arguments in the MINX function and I am not sure how to fix it.