Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Query prices for certain ID at maximum date

Hi community! I am trying to build a measure to set a query for the prices [Cotacao] for the ID product [ID_FW]=21, [Validade]=1, in every segment[Prazo], for the last/max date [Data_Cotacao].   ...
Need Help
Tips and Tricks
Kumail's avatar
Kumail
Impactful Individual
5 years ago

Hello Anonymous 

 

You can update the formula to 

 

MAxDateUpdate = 
CALCULATE(AVERAGE(data[Cotacao]), data[ID_FW]=21, data[Validade]=1, LASTDATE(data[Data_Cotacao]))

 

Let me know if this helps. 

 

Regards

Kumail Raza

Anonymous's avatar
Anonymous
Not applicable
5 years ago

No Kumail , unfortunately I still have [Prazo] form another dates.

  • Kumail's avatar
    Kumail
    Impactful Individual
    5 years ago

    Anonymous 

     

    Can you send screenshots of the error here.

     

    Regards

    Kumail Raza

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      the expression refers to multiple columns. multiple columns cannot be converted to a scalar value