Forum Discussion

MagisKoen's avatar
MagisKoen
Frequent Visitor
4 years ago
Solved

Calculated Colums with multiple tables

So I have 2 tables and using some formula in the calculated columns section i want to create a new column. It looks like this:   Table 1:  reference | some string | datetime r1 | aa | 29/11/2021 ...
Need Help
  • Aburar_123's avatar
    Aburar_123
    4 years ago

    Hi MagisKoen ,

     

    Please find the solution below,

     

    Column4 = CALCULATE(max('Table'[Column3]),FILTER('Table','Table'[Column1]=EARLIER('Table'[Column1])))
     
    result is as below,

    Please like and mark it as a solution if it give right answer to you. thanks

Aburar_123's avatar
Aburar_123
Solution Supplier
4 years ago

Hi MagisKoen ,

 

Please find the solution below,

 

Column4 = CALCULATE(max('Table'[Column3]),FILTER('Table','Table'[Column1]=EARLIER('Table'[Column1])))
 
result is as below,

Please like and mark it as a solution if it give right answer to you. thanks

  • MagisKoen's avatar
    MagisKoen
    Frequent Visitor
    4 years ago

    Thank you a lot Aburar_123, I did need to put in a Lookupvalue to transpose the data to the other table but this works!