Forum Discussion

Analitika's avatar
Analitika
Post Prodigy
5 years ago

Multiply each row by Max value grouped by group id

I have two tables

 

Table1

GroupID | CountOfSomething

 

Table2

GroupID | Price

 

I need get Max value from Table1 by GroupID and multiply by Table2 same group price

How to write measure to do that?

No RepliesBe the first to reply