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
See if this is what you need
Cost = CALCULATE(MAX(Tabela 1[Custo]), RELATEDTABLE(Tabela 1))
This calculated column formula will work in Table2 without any relationship between the 2 tables.
Hope this helps.
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.