cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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

NameCost
LH575
LH575
LH575
GT623
GT685
GT250
SH654

 

Table 2

NameCost
LH575
GT685
SH654
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User II
Super User II

Hi @kraj 

you can do it like this:

 

25-09-_2020_23-28-41.png

 

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)

View solution in original post

3 REPLIES 3
Highlighted
Helper I
Helper I

Hello  @kraj 

 

See if this is what you need


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

Highlighted
Super User II
Super User II

Hi @kraj 

you can do it like this:

 

25-09-_2020_23-28-41.png

 

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)

View solution in original post

Highlighted
Super User III
Super User III

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
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors