Forum Discussion
Replacing Measure with Calculated Column (or display ImageURL with Measure)
I ran into the following problem. I have a TableA that contains a sensorId, timestamp and value column. I have a second tableB with a sensorId column, and a ManyToOne relationship between TableA and ...
Okay, with some more trial and error I found that using
TwoHourMax = CALCULATE(MAX(TableA[Value]) ;FILTER(TableA; TableA[sensorID] = [sensorID] && TableA[Timestamp] > TableB[Max timestamp] - Time(2;0;0)))
does work. So it's less urgent, but I'm still open to any less ugly solutions.