Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
Solved! Go to Solution.
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)
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.
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)
Hello @kraj
See if this is what you need
Cost = CALCULATE(MAX(Tabela 1[Custo]), RELATEDTABLE(Tabela 1))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
98 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |