Forum Discussion
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...
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])
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.