Forum Discussion
Date range based on group column
Id Date Amount 1 05/05/2019 50 1 10/05/2019 200 1 15/05/2019 200 1 20/05/2019 200 1 21/05/2019 200 2 05/05/2019 100 2 10/05/2019 150 2 15/05/2019 115 2...
Hi Anonymous
Add a measure like this to you visual.
Date Range_ =var _ID = SELECTEDVALUE(Sheet1[ID])var _MinDate = CALCULATE(MIN(Sheet1[Date]), Sheet1[ID] = _ID)var _MaxDate = CALCULATE(MAX(Sheet1[Date]), Sheet1[ID] = _ID)ReturnCONCATENATE(CONCATENATE(_MinDate, " - "), _MaxDate)
aj1973
Community Champion
Community ChampionHi Anonymous
Add a measure like this to you visual.
Date Range_ =
var _ID = SELECTEDVALUE(Sheet1[ID])
var _MinDate = CALCULATE(MIN(Sheet1[Date]), Sheet1[ID] = _ID)
var _MaxDate = CALCULATE(MAX(Sheet1[Date]), Sheet1[ID] = _ID)
Return
CONCATENATE(CONCATENATE(_MinDate, " - "), _MaxDate)