Forum Discussion
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]. ...
Anonymous
The file is given below for your reference.
https://drive.google.com/file/d/1iAkJAvLyQU_pvM-39RhX2yukjUbpLQZX/view?usp=sharing
I hope this helps or you can send the screenshot from data where the logic fails.
Regards
Kumail Raza
No Kumail , unfortunately I still have [Prazo] form another dates.
Anonymous
Can you send screenshots of the error here.
Regards
Kumail Raza
the expression refers to multiple columns. multiple columns cannot be converted to a scalar value
Anonymous
The file is given below for your reference.
https://drive.google.com/file/d/1iAkJAvLyQU_pvM-39RhX2yukjUbpLQZX/view?usp=sharing
I hope this helps or you can send the screenshot from data where the logic fails.
Regards
Kumail Raza