Forum Discussion

ALEX2011ALfer_'s avatar
4 years ago

every 8 days value

      Indicator value = var maxdate = MAX(data[Date]) var last6month = DATE(YEAR(maxdate), MONTH(maxdate) - 6, DAY(maxdate)) Return IF( LOOKUPVALUE('Date'[Last 8 days dates], 'Date'[Last 8 d...