Forum Discussion

savne's avatar
savne
New Member
2 years ago

Displaying data for previous dates from same week on line chart

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.

 

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    2 years ago

    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's avatar
      savne
      New Member
      2 years ago

      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.