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?
Go to Solution.
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 homeFrankAT (Proud to be a Datanaut)
View solution in original post
This calculated column formula will work in Table2 without any relationship between the 2 tables.
Hope this helps.
See if this is what you need
Cost = CALCULATE(MAX(Tabela 1[Custo]), RELATEDTABLE(Tabela 1))
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.