bring text with max column condition data, but returns "erro a table of multiple values"

[Anonymous]

Hi there!

Someone can help me?

I  need bring a text value with condition max data, but into table, contains many duplicate values...

I try this function below:

LastSituation =

VAR Latest_Time_ =

CALCULATE (

MAX ( HISTORICO_COTAS[DATA_SITUACAO] );

FILTER ( ALL ( HISTORICO_COTAS[ID_COTA] ); HISTORICO_COTAS[ID_COTA] = VENDAS[ID_COTA] )

)

RETURN

LOOKUPVALUE (

HISTORICO_COTAS[CD_SITUACAO_COBRANCA];

HISTORICO_COTAS[ID_COTA]; VENDAS[ID_COTA];

HISTORICO_COTAS[DATA_SITUACAO]; Latest_Time_

)

message error: A table of multiple  values was supplied where a single value was expected.

Thank you in advance!

[Greg_Deckler]

Is that a measure or a column?  Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[Anonymous]

Hello @Greg_Deckler 

I prefer column, but if any measure helps, i acept too hahah

[v-piga-msft]

Hi @Anonymous ,

More details will be much better.

If it is convenient, could you share the data sample which could reproduce the scenario and your desired output so that we could help further on it?

Best  Regards,

Cherry