Forum Discussion

New Member

5 years ago

Solved

Calc column from column in other table

Hi all,

I am new to Power Bi, and I hope someone can help solve my little headache explained below

I have Table 1 and table 2, and I wish to calculate a new column in table 2 based on table 1.

The new column should contain the maximum cost value form Table 1 as illustrated in the example below.

Can anyone help?

Table 1

Name	Cost
LH	575
LH	575
LH	575
GT	623
GT	685
GT	250
SH	654

Table 2

Name	Cost
LH	575
GT	685
SH	654

FrankAT
5 years ago
Hi kraj

you can do it like this:

Max Cost = MAXX(RELATEDTABLE(Table1),Table1[Cost])

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)

3 Replies

Anonymous
Not applicable
5 years ago
Hello kraj

See if this is what you need

Cost = CALCULATE(MAX(Tabela 1[Custo]), RELATEDTABLE(Tabela 1))
FrankAT
Community Champion
5 years ago
Hi kraj

you can do it like this:

Max Cost = MAXX(RELATEDTABLE(Table1),Table1[Cost])

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)
Ashish_Mathur
Super User
5 years ago
Hi,

This calculated column formula will work in Table2 without any relationship between the 2 tables.

=CALCULATE(MAX(Data[Cost]),FILTER(Data,Data[Name]=EARLIER(Data1[Name])))

Hope this helps.

Related content