Can't show Image URL in matrix on recent date.

[can5539]

 I need to show status(image URL GREEN/ORANGE/RED) of transformer at every location on recent date that workers do oil dielectric test but dashboard still shows wrong image URL.

For example

     DATE                           Status

  1/1/2020         Red(should change oil)

  2/1/2020         orange(should filter oil)

  3/1/2020         Green(good condition)

In Matrix

                           No.

                           Substation No.

Location            Green

[amitchandak]

@can5539 , you can create a measure to return URL and at recent date only and change is the type to URL

Measure = calculat(max(Table[url]), filter(Table[Date]=lastedate(Table[Date]))

[can5539]

@amitchandak It shows error "The argument is passed too little to the FILTER function. The minimum number of arguments for this function is 2."

I can't do your recommendation.

[amitchandak · Accepted solution]

@can5539 , Try one of the 2

Measure =
var _max = calculate(lastedate(Table[Date]))
return
calculat(max(Table[url]), filter(Table,Table[Date]=_max))

or

Measure =
var _max = maxx(allselected(Table),Table[Date])
return
calculat(max(Table[url]), filter(Table,Table[Date]=_max))

[can5539]

@amitchandak I try out your solution. It works!Thank you for your help.

[amitchandak]

@can5539 , Try like

Measure = calculat(max(Table[url]), filter(Table,Table[Date]=lastedate(Table[Date]))

[can5539]

@amitchandak It shows red image in all cells. It still shows wrong data.