cancel
Showing results for
Did you mean:
New Member

## 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
1 ACCEPTED SOLUTION
Community Champion

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 3
Super User

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.

Regards,
Ashish Mathur
http://www.ashishmathur.com
Community Champion

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)

Helper I

Hello

See if this is what you need

Cost = CALCULATE(MAX(Tabela 1[Custo]), RELATEDTABLE(Tabela 1))

Announcements

#### Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

#### Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

#### What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.